select * from emp where dept in( select dept from emp where emp_idn='02' group by dept having count(*)>1)
select * from emp where dept in (select dept from emp where emp_idn = '02' group by dept having count(*) > 1)
select tt.* from ( select t.* RANK() OVER (PARTITION BY t.dept order by rownum) Rnk from emp t where t.emp_idn = 02---员工职位是02 )tt where tt.rnk >= 2lz可以参考一下上边的思路.应该可以实现你的要求.
SELECT * FROM (SELECT DEPT, EMP_IDN, COUNT(EMP_IDN) OVER(PARTITION BY EMP_IDN) GS FROM EMP WHERE DEPT = '某个部门') WHERE GS > 1
from emp
where dept in(
select dept
from emp
where emp_idn='02'
group by dept
having count(*)>1)
select * from emp where dept in
(select dept from emp where emp_idn = '02' group by dept having count(*) > 1)
select tt.*
from (
select t.*
RANK() OVER (PARTITION BY t.dept order by rownum) Rnk
from emp t
where t.emp_idn = 02---员工职位是02
)tt
where tt.rnk >= 2lz可以参考一下上边的思路.应该可以实现你的要求.
FROM (SELECT DEPT, EMP_IDN, COUNT(EMP_IDN) OVER(PARTITION BY EMP_IDN) GS
FROM EMP
WHERE DEPT = '某个部门')
WHERE GS > 1