SQL filter duplicate records and query duplicate records

-- Remove duplicate records from a table. UserID is the auto-increment primary key and RoleID is the repeated field.

The code is as follows:	Copy code
Select min (UserID) AS UserID, RoleID FROM tmpTable group by RoleID SELECT RoleID FROM tmpTable group by RoleID HAVING (COUNT (*)> 1) get duplicate records Select distinct * FROM tmpTable filtering duplicate records