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 does php communicate with mysql?
Is mysql open source?
What is an index? How can an index be declared in mysql?
How do I rename a procedure?
Which datatype is used for email in mysql?
What is mysql architecture?
What does mysql flush hosts do?
How to drop an existing view in mysql?
How do I restore a database in mysql workbench?
What does mysqli stand for?
How can I see mysql database?
How to validate email addresses in mysql?
Where is mysql data stored?
How to list or view all databases from the mysql server.
What is the return type of mysqli_query?