关于SQL Server having

关于SQL Server having

查找user_code出现重复的情况

select user_code, count(user_code) as num from app_users group by user_code having count(user_code) > 1

 

发表回复

您的电子邮箱地址不会被公开。