SELECT country,city
FROM customers
GROUP BY country
ORDER BY city DESC
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 |
Post New Answer View All Answers
How do I edit a trigger in mysql?
What are the security alerts while using mysql?
How many ways to get the current time?
How to find the unique values if the value in the column is repeated?
How to create a new table in mysql?
How can I create table in mysql?
What is flush privileges in mysql?
What is database clustering in mysql?
How to use in conditions?
How does triggers work in mysql?
What is a left join mysql?
How do I transfer data from one database to another in mysql?
What is mysql routine?
How do I start mysql database?
What are the advantages of MySQL when compared with Oracle?