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
Where is mysql data stored?
How do you connect MySQL database with PHP?
How to return query output in xml format?
Why we use mysql workbench?
Can we write pl sql mysql?
what are the different tables present in mysql? : Mysql dba
How to delete a table.
How important is to list the column names when doing an insert?
How do I rename a procedure?
What are different types of queries?
What is the use of procedure in mysql?
What is full form of xampp?
How to create and drop view in mysql?
What are the different mysql database engines?
What mysql -u john -p command does?