Shulou(Shulou.com)05/31 Report--

This article is about how sql filters out duplicate data. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Sql filters out duplicate data by using the "select * from table name where condition" statement; you can use one or more tables, split them with commas (,), and use the where statement to set query conditions.

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

Open the database on your computer and create a new user table with duplicate data as an example.

The duplicate data of the user table in the database is queried.

Select * from user where name in (select name from user group by name having count (name) > 1)

Delete data with duplicate names

Delete from user where name in (select name from user group by name having count (name) > 1)

Get rid of duplicate data. Zhang San's duplicate data has been removed here.

Select distinct name from user

Get rid of the same duplicate data in the class

Select distinct class from user

Remove duplicate data from two fields

Select distinct name,class from user

Thank you for reading! This is the end of the article on "how to filter out duplicate data by sql". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.