SELECT country,city
FROM customers
GROUP BY country
ORDER BY city DESC
Answer Posted / vardhan rao
This Query will delete the duplicate values in GROUP BY clause
Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
What is the difference between heap table and temporary table?
Can we write procedure in mysql?
Is mysqli deprecated?
Can we store videos in mysql database?
What is the data source name for mysql?
How to delete an existing column in a table?
Why mysql is open source?
What is difference between oracle sql and mysql?
What is the default port of mysql server?
Why do we use the mysql database server?
What is table level locking in mysql?
What are the advantages and disadvantages of using mysql?
In which language it is written?
Is mysql a distributed database?
Explain triggers and stored procedures?