查询表里user_name字段不为空 且 每个user_id对应的记录条数大于1的user_id有哪些用语句
select user_id,count(*) from user where user_name is not null group by user_id having count(*)>1;
查询表里user_name字段不为空 且 每个user_id对应的记录条数大于1的user_id有哪些用语句
select user_id,count(*) from user where user_name is not null group by user_id having count(*)>1;