[SQL] How to select all attributes (*) with distinct values in a particular column(s)?

Here is link to the w3school database for learners:

W3School Database

If we execute the following query:

SELECT DISTINCT city FROM Customers

it returns us a list of different City attributes from the table.

What to do if we want to get all the rows like that we get from SELECT * FROM Customers query, with unique value for City attribute in each row.

Continue reading...