17,090
社区成员
发帖
与我相关
我的任务
分享
create table emp
(EMPNO ,ENAME, SAL ,DEPTNO
)
as
select '7788','SCOTT',3000,20 from dual
union
select '7521','WARD',1250,30 from dual
union
select '7654','MARTIN',1250,30 from dual
union
select '7903','FORD',3100,20 from dual
union
select '7904','FORD2',3100,20 from dual
select *
from
(
select a.*,count(empno) over(partition by sal) num
from emp a
)
where num>1
order by SAL DESC
--结果:
7903 FORD 3100 20 2
7904 FORD2 3100 20 2
7521 WARD 1250 30 2
7654 MARTIN 1250 30 2
select *
from
(
select a.*,count(empno) over(partition by sal) num
from emp a
)
where num>1
order by SAL desc