It will only return 1 row per country and will display only the city that i

SELECT country,city
FROM customers
GROUP BY country
ORDER BY city DESC

Question Posted / rod sohrabi

Answer Posted / rod sohrabi

It will only return 1 row per country and will display only the city that is reverse alphabetical order

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do I edit a trigger in mysql?

898

What are the security alerts while using mysql?

1039

How many ways to get the current time?

976

How to find the unique values if the value in the column is repeated?

995

How to create a new table in mysql?

1050

How can I create table in mysql?

1032

What is flush privileges in mysql?

997

What is database clustering in mysql?

1039

How to use in conditions?

1014

How does triggers work in mysql?

975

What is a left join mysql?

905

How do I transfer data from one database to another in mysql?

910

What is mysql routine?

941

How do I start mysql database?

980

What are the advantages of MySQL when compared with Oracle?

934