SQL queries data with the same fields. SQL queries fields.

SQL queries data with the same fields. SQL queries fields.

Has the following table

Movestar (id, name, title, address) with the following content:

Search for all persons with the same title and address

Copy codeThe 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;

Result:

Key Point: used <. If used <>, the content is repeatedly listed.

The above is all the content of the data with the same fields in the SQL statement. I hope you can give us a reference, and hope you can provide more support for the customer's house.