max data

[ha1]

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

[AOrehek]

SELECT your_number from
( SELECT ROWNUM rn, your_number from your_table ORDER BY your_number ) WHERE rn = 250;