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

What is mysql connection limit?

971

What is the difference between char and varchar in mysql?

1193

How many queries can mysql handle?

1022

What is mysql installer?

1046

How do I free up space in mysql?

964

What is the use of mysql_fetch_array () function in php?

1002

What is the storage engine for mysql?

1008

What is the latest mysql?

1000

How to list or view all databases from the mysql server.

976

What is mysql default port number?

1054

Does facebook still use mysql?

976

What does mysqli stand for?

990

What is the maximum number of columns per table?

963

What is maximum table size in mysql?

988

How many columns can a mysql table have?

956