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 check mysql version?
What is mysql server?
Why we use mysql workbench?
Differentiate CHAR_LENGTH and LENGTH?
What data structure does mysql use?
How we can see all indexes defined for a table in mysql?
How can we optimize stored procedure?
How do you kill a long running query in mysql?
How can we get total number of records by query in mysql?
How do I start and stop mysql server?
What is the difference between char and varchar in mysql?
What does "i_am_a_dummy flag" do in mysql?
why not null is not allowed at table level
What is a definer?
What is mysqlcommand?