Friday, August 8, 2008

Nth row of table

SQL> select a, r from ( select a,rownum r from t_temp order by a desc) where r=3;

No comments: