A、select max(sal) from tab where sal <max(select sal from> B、select min(sal) from (select sal from tab order by sal limit 2)
C、select sal from tab order by sal desc limit 1 offset 1
D、select max(sal) from tab where sal not in (select max(sal) from tab)