如果要查询emp表工资最高和最低的员工姓名(排除工资为null)
按以前的想法一条简单的语句似乎不好实现
最常见的是先升序取最小,再降序取最大
有了First/Last排名后就不一样了
select
min
(ename) keep(dense_rank first
order
by
sal
desc
nulls last) first,
min (ename) keep(dense_rank last order by sal desc nulls first) last
from emp
min (ename) keep(dense_rank last order by sal desc nulls first) last
from emp