08 2021 档案

SQL语句之查找重复记录和唯一记录
摘要：查找唯一记录 SELECT DISTINCT * FROM people; 查找重复记录 SELECT * FROM people WHERE peopleID in ( SELECT peopleID FROM people GROUP BY peopleID HAVING count(peopl 阅读全文
posted @ 2021-08-30 22:14 ruishu_0726 阅读(601) 评论(0) 推荐(0)