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
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
What is view? How can you create and drop view in mysql?
How do I copy a table in mysql?
How much does mysql enterprise cost?
How to drop an existing index in mysql?
Is mysql free for enterprise?
How to delete a trigger in mysql?
Why we use mongodb instead of mysql?
Is oracle mysql free?
how to Return total number of rows.
What is dblink?
How do I find the database name in mysql?
In how many ways we can retrieve data in the result set of mysql using php?
How do I find the size of a mysql database?
What sql does mysql use?