SELECT country,city
FROM customers
GROUP BY country
ORDER BY city DESC
Answer Posted / prajakta
this is right coz here order by clause is at the end of
query...
| Is This Answer Correct ? | 21 Yes | 3 No |
Post New Answer View All Answers
How to use count function in mysql?
How many triggers are possible in mysql?
How do I view a mysql database?
Is mysql deprecated?
What is striped backup
What is latest version of mysql?
How to extract a unit value from a date and time?
What is mysql shell?
Is sql and mysql same?
How much does mysql enterprise cost?
What is 'mysqldump'?
What is deterministic in mysql?
What is the purpose of mysql database?
How do you rename a procedure in mysql?
How important is to list the column names when doing an insert?