MySQL删除重复项

Question

这个问题已经有答案了:

Remove duplicate rows in MySQL (28 个回答)

已关闭 9 年前。

有一个表格:

NAME |    DATE    | INFO  | SPEC
Bob  | 01.01.2010 | Text1 | Student
Ann  | 02.02.2020 | Text2 | Secretary
Bob  | 01.01.2010 | Text1 | Student
John | 03.03.2030 | Text3 | Tester
Bob  | 01.01.2010 | Text1 | Student

我怎样才能得到这样的 table (根据要求):

NAME |    DATE    | INFO  | SPEC
Bob  | 01.01.2010 | Text1 | Student
Ann  | 02.02.2020 | Text2 | Secretary
John | 03.03.2030 | Text3 | Tester

PS:这些变体不起作用:

SELECT DISTINCT Name, Date, Info, Spec FROM Table
SELECT DISTINCT * FROM Table
SELECT Name, Date, Info, Spec FROM Table GROUP BY Name, Date, Info, Spec
SELECT * FROM Table GROUP BY Name, Date, Info, Spec

Answer 1

您需要使用DISTINCT关键字

尝试这样的查询:

SELECT DISTINCT * FROM table