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
What is mysql_query?
Why do we use mysql?
How do I get a list of table names in mysql?
How do I exit mysql?
How many primary keys can be there in a table?
How do I find users in mysql?
What do you understand by mysql terminal?
What can you do with mysql?
What is the function of mysqldump?
What you can use regular expression for in mysql?
Where is the myisam table stored?
Can you tell the difference between $message and $$message?
What is truncate in mysql?
What do we use to remove duplicate records while fetching a data in mysql ?
Why do we use the mysql database server?