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 flush privileges in mysql?
How do I view data in mysql workbench?
What are the indexes in mysql?
How can we encrypt and decrypt a data presented in a table using mysql?
What are the objects can be created using CREATE statement?
What is data types in mysql?
What is regex in mysql?
Where is the mysql config file?
What is the difference between mysql and oracle?
Explain timestamp?
State the differences between mongodb and mysql.
Which storage engine is best in mysql?
How do I rename a procedure?
How to set the time zone for MySQL to particular country time?
How you can create a trigger in mysql?