查询一个表中的两个字段值相同的数据

select user_id,count(user_id) as '出现重复的次数' from sys_user_position GROUP  BY user_id  HAVING count(user_id)> 1