请问：是否有条sql语句能直接判断表中的某一列有重复的值？

[abedon]

不想用循环去做比较：-（

[alen_fen]

加上 group by 列名 having count(*)>1

• 打赏
• 举报

回复 赞

[Yang_]

select colname,count(*) as ColNameCount from TableName
group by colname
having count(*)>1

• 打赏
• 举报

回复 赞

[leimin]

UP

• 打赏
• 举报

回复 赞