--列出薪水高于在部門30號作業的所有員工的薪水的員工姓名和薪水,部門名稱,部門人數
select e.ename, e.sal, d.dname,en
from emp e, dept d,(select count(ename)en from emp where sal >
(select max(sal) from emp where deptno = '30' group by deptno)group by deptno)
where e.deptno = d.deptno
and sal >
(select max(sal) from emp where deptno = '30' group by deptno)
這個重復值去不掉呀呀呀



轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/266805.html
標籤:基礎和管理
上一篇:請問下圖這個題的換行怎么寫呀?
