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!

SQL FUNCTION to compute MEDIAN

189421Jan 30 2002

Hi

Just as we use MAX and MIN to compute the maximum and minimum values using SELECT query in SQL, does anyone know of a direct/indirect function/method to calculate the MEDIAN of a given set of values. Powerbuilder provides median function. I am looking forward to doing this using SQL/PLSQL.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 6 2002

Added on Jan 30 2002

3 comments

782 views