最近练习用开窗函数写的

where id  in (
select A.id
from
	(
		select *,rank() over (partition by emp_no order by id) rk from titles_test
	) A
where A.rk > 1)