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

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

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.