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
What are the column comparisons operators?
What is dirty read and phantom read?
What is difference between unix timestamp and mysql timestamp?
What is pdo connection?
What's the difference between mysql and sql server?
What is a transaction? Describe mysql transaction properties.
Why is the basic difference between left join, right join and inner join?
What is logs in mysql?
What is the data type for file in mysql?
What are the two types of queries?
What is database url for mysql?
How is mysql database stored?
Is mysql a database?
How do I run mysql?
How to write date and time literals?