This Query will delete the duplicate values in GROUP BY clause

SELECT country,city
FROM customers
GROUP BY country
ORDER BY city DESC

Question Posted / vardhan rao

Answer Posted / vardhan rao

Is This Answer Correct ?

3 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Does mysql automatically index foreign keys?

928

Can we store images in mysql database?

907

What is database clustering in mysql?

1036

How you will show all data from a table.

988

What are the differences between char and varchar data types?

1107

How can we find out which auto increment was assigned on Last insert?

1098

How to get current MySQL version?

1089

What is a csv table?

1001

How to enable or disable a row of a table using MySQL in struts?

4099

using primary can we relate two table, with out foreign key?

2711

Does mysql scale well?

892

How can I create a database in mysql?

866

How can you count the total number of records of any table?

921

How do I restore a mysql database?

1085

What is triggers and how it can be used in mysql?

971