SQL> select * from paul;
A B
---------- ----------
12 13
10 15
11 10
13 15
SQL> select max(B) from paul where B<(select max(B) from paul);
MAX(B)
----------
13
SQL>
SQL> select max(b) from (
2 select b,dense_rank() over(order by b desc) m from paul)
3 where m>1;
MAX(B)
----------
13
select distinct b from
(
select b,dense_rank() over(order by a desc) m from paul
) t
where t.m=2;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/7199859/viewspace-394/ ,如需转载,请注明出处,否则将追究法律责任。