SELECT country,city
FROM customers
GROUP BY country
ORDER BY city DESC
- 5 Answers
- 9838 Views
- HCL, I also Faced
- E-Mail Answers
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
How do I kill a mysql connection?
Who developed mysql?
Explain about the architecture of MYSQL?
What are the advantages/disadvantages of mysql and php?
What is the difference between truncate and delete in mysql?
i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?
Is mysql workbench a dbms?
Why to use char instead of varchar in the database?
Is mysql good for large database?
What are the two types of queries?
How do I change global variables in mysql?
In mysql, what is the default storage engine?
explain GROUPBY & HAVING clause with examples.
How do I start mysql in ubuntu?
What is the default port for MySQL Server?
