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 query log in mysql?
How do I zip a file in mysql?
Is mysql and sql are same?
What is myisamchk?
Is mysql same as sql?
How to extract a unit value from a date and time?
I want to find out all databases starting with ‘test’, I have access to?
How many ways to get the current time?
How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.
How do I clear the screen in mysql?
What does mysql flush privileges do?
Why mysql is open source?
What is the use of pdo?
What is the difference between the primary and unique key in mysql?
Write a query to retrieve a hundred books starting from 20th.