SELECT country,city
FROM customers
GROUP BY country
ORDER BY city DESC
Answers were Sorted based on User's Feedback
Answer / prajakta
this is right coz here order by clause is at the end of
query...
Is This Answer Correct ? | 21 Yes | 3 No |
This is wrong because there is no aggregate function in the
query when a group by clause is used.
The above query could be like:
1. SELECT country, count(city)
2. FROM customers
3. GROUP BY country
4. ORDER BY country DESC
* Correction at line 1 & 4.
Is This Answer Correct ? | 12 Yes | 9 No |
Answer / 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 |
Answer / vardhan rao
This Query will delete the duplicate values in GROUP BY clause
Is This Answer Correct ? | 3 Yes | 5 No |
What are the features of mysql?
How can a user get the current SQL version?
How do you name a table?
How can you increase the performance of mysql select query?
How do I automate a backup in mysql?
How do I delete a mysql user?
How to show all tables with 'mysql'?
How do I tune a mysql query?
Is mysql a dbms?
What are the purposes of using enum and set data types?
What is full text indexing in mysql?
How do you create a new database in mysql?