SQL to find exactly the same data in a few fields _mssql

Have one of the following tables

MoveStar (id,name,title,address), content is:

Now you want to find all the people with the same title and address

Copy Code code as follows:

Select Star1.name,star2.name,star1.title,star1.address
From MoveStar as star1,movestar as Star2
where star1.title = Star2.title
and star1.address = star2.address
and Star1.name < Star2.name;

Results:

Main points: Use the, if <> will repeat the contents of the list

The above is the SQL to find a few fields exactly the same data all the content, I hope to give you a reference, but also hope that we support the cloud-dwelling community.