Question

如何写出一个SQL语句 ，查询出数据库的重复记录行

Answer 1

看下面这个例子，可以应该可以帮你实现：
表KILO
ID CREDIT
100 100
100 100
101 122
101 122
111 222
113 223

CREATE TABLE KILO (ID INT ,CREDIT INT)
INSERT INTO KILO VALUES(100,100)
INSERT INTO KILO VALUES(100,100)
INSERT INTO KILO VALUES(101,122)
INSERT INTO KILO VALUES(101,122)
INSERT INTO KILO VALUES(111,222)
INSERT INTO KILO VALUES(113,223)

SQL实现查询出重复记录行：
SELECT * FROM KILO WHERE ID IN (SELECT ID FROM KILO
GROUP BY ID
HAVING COUNT(ID)<2)

Answer 2

SELECT * FROM 表名 WHERE ID IN (SELECT ID FROM 表名GROUP BY ID
HAVING COUNT(ID)<2)