查找唯一记录
SELECT DISTINCT * FROM people;
查找重复记录
SELECT * FROM people WHERE peopleID in ( SELECT peopleID FROM people GROUP BY peopleID HAVING count(peopleID)>1);
2021-08-30 22:13:35
相关文章
- 09-29SQL操作语句之查询及删除重复记录的方法
- 09-29SQL语句之查找重复记录和唯一记录
2023-09-29 09:41:16
查找唯一记录
SELECT DISTINCT * FROM people;
查找重复记录
SELECT * FROM people WHERE peopleID in ( SELECT peopleID FROM people GROUP BY peopleID HAVING count(peopleID)>1);
2021-08-30 22:13:35