[Q]如何取得一列中第N大的值?
[A]select * from
(select t.*,dense_rank() over (order by t2 desc) rank from t)
where rank = &N;
[A]select * from
(select t.*,dense_rank() over (order by t2 desc) rank from t)
where rank = &N;
select * from
(select t.*,dense_rank() over (order by t2 asc) rank from t)
where rank = 2;
oracle好象不支持top,我的9i不可以。
---------
14
SQL> select max(sl1) from a where sl1<>(select max(sl1) from a); MAX(SL1)
---------
13
自己试一下,我没有测试,应该是可以的。