select min(sal) keep(dense_rank first order by sum(sal) asc) first,
min(sal) keep(dense_rank last order by sum(sal) asc) last
from emp
group by sal
为什么取不到5000 呢?
...全文
274回复打赏收藏
oracle first last
select min(sal) keep(dense_rank first order by sum(sal) asc) first, min(sal) keep(dense_rank last order by sum(sal) asc) last from emp group by sal 为什么取不到5000 呢?