hi all,
there is a table in which there is one column whose datatype is numeric. in this there are 300 rows. i want 250th maximum value of that table. how we can get it.
bye
thanks
Printable View
hi all,
there is a table in which there is one column whose datatype is numeric. in this there are 300 rows. i want 250th maximum value of that table. how we can get it.
bye
thanks
SELECT your_number from
( SELECT ROWNUM rn, your_number from your_table ORDER BY your_number ) WHERE rn = 250;