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 呢?
min(sal) keep(dense_rank last order by sum(sal) asc) last
from emp
group by sal为什么取不到5000 呢?
min(sal) keep(dense_rank last order by sal asc) last
from emp
sal sum(sal)
2850.00 5700此时5700大于5000.所以你sql查出来的是2850,而不是5000.。。
既然这样何必跑到这个bbs上来发帖子,直接私下聊就解决了。