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 connector used for?

947

How to use triggers to track changes in mysql?

877

What is mysql and why it is used?

1087

Can we join 3 tables in mysql?

963

what is the difference between gui testing and database testing? : Mysql dba

1100

What is the current mysql version?

1023

What is the maximum size of mysql database?

957

How to run 'mysql' commands from a batch file?

1062

What are the differences between a primary key and foreign key?

1102

What is mysqli_connect_error ()?

1034

How do I view mysql logs?

891

What is insert query in mysql?

916

How to delete the repeated records from a table?

981

How many rows we can insert in a mysql table?

967

What happens if you no create privilege in a database?

1120