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 current root password of mysql?
how to display nth highest salary from a table in a mysql query? : Mysql dba
What is session variable in mysql?
What are the critical issues you have resolved in your company
Is mysql from oracle?
Can we store files in mysql?
How to escape special characters in sql statements?
How do you restart mysql?
What is mysql primary key?
How to make a copy values from one column to another in mysql?
What are ddl statements in mysql?
What is action query?
How do I assign a variable in mysql?
Is mysql good for big data?
Does insert statement lock the table?