SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Percentile Calculation

527451Mar 12 2010 — edited Mar 12 2010

Hi Gurus,

Table: T1
-----------------------------
C1 C2
----------------------------
10 425
10 360
10 455
10 505
20 204
20 106
20 55
20 175
-----------------------------
How to calculate the (25th, 50th, 75th )Percentiles for the column "C2" group by "C1".

Greatly appreciate your help.

Thanks in Advance
Partha

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 9 2010

Added on Mar 12 2010

2 comments

1,113 views