查看id(某个字段)是否唯一

查看id(某个字段)是否唯一


SELECT id, count(1) as t FROM temp GROUP BY id HAVING count(1)>1

posted @ 2022-02-09 16:48  EmptyJar  阅读(64)  评论(0)    收藏  举报