How to find the exact same data in several fields in SQL
How to find the same data in several fields in SQL? for this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.
There is a table below
Movestar (id,name,title,address), which reads:
Now find all the people with the same title and address
The copy code is 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:
Key point: use the
