oracle 查询某列有重复的值

admin

SELECT user_id, COUNT(*)
FROM LJACCOUNT
GROUP BY user_id
HAVING COUNT(*) > 1;

查询  LJACCOUNT  中user_id 有重复的

admin

select accountid,accountname,orgtype,p_limit,p_limit_u,p_limit_s from  LJACCOUNT where user_id='J00043100001183'