How to filter duplicate data in SQL

How to filter duplicate data in SQL, many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can get something.

In the article "SQL de-duplicated data", we talked about how to remove duplicate data. In our work, we sometimes need to filter the duplicated data for further comparison. In the following table, we want to filter out the data with the same name.

Idnamescore1 Xiao Wang 512 Xiao Wei 613 Xiao Zhang 714 Xiao Li 515 Xiao Wang 51SELECT * FROM tbl WHERE name = (SELECT name FROM tbl GROUP BY name HAVING COUNT (name) > 1) idnamescore1 Xiao Wang 515 Xiao Wang 51 is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.