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 happens if null values are involved in expressions?
What are the difference between and myisam and innodb?
What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
How large can a mysql table be?
What you can use regular expression for in mysql?
How database are managed?
In which year mysql created?
How do I create a database in mysql workbench?
Why do you think it is advised to not to use guid and character columns as clustered index arrays?
Which datatype is used for email in mysql?
Is mysql better than oracle?
How many ways to get the current time?
How to convert dates to character strings?
How to show all tables with 'mysql'?
Write a query to display current date and time?