How do I delete the content in the table below to meet in the name of the same working class same duplicate values, only keep a
Name class working course
Liu 2, 4, 5
Liu 2 4 12
Liu 2 4 11
3, 7 6 jiang
Jiang 3 July 78
Jiang 3 7 45

CodePudding user response:

What database, or excel spreadsheets,

CodePudding user response:

Delete from list a where clause (Anderson, d, a.s eq) in (select Id, seq from table group by Id, seq having the count (*) & gt; 1) and the rowid not in (select min (the rowid) from table group by Id, seq having the count (*) & gt; 1) remember to add a ID