SQL statement for querying duplicate data and removing duplicate records

For example, you can query and list duplicate data twice.

The code is as follows:	Copy code
Select * from park_room where parkNum in ( Select parkNum from park_room Group by parkNum Having count (parkNum)> 1 ) Order by parkNum field information description: Park_room -- parking space table ParkNum -- parking space number

Example

Remove duplicate records

The code is as follows:	Copy code
Select count (distinct parkNum) AS num FROM park_room WHERE 'aread' = 1 AND 'status' = 0 LIMIT 1