面试题（一）-sql查询重复数据

sql语句

select b.* from user b where b.user_name in 
(-- 1 start
select a.user_name from 
(-- 2 start
select u.user_name,count(u.user_name) as userNum from user u group by u.user_name
)a-- 2 end
where a.userNum >=2
)-- 1 end