SELECT country,city
FROM customers
GROUP BY country
ORDER BY city DESC
- 5 Answers
- 9824 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / rod sohrabi
It will only return 1 row per country and will display only the city that is reverse alphabetical order
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What does mysqli stand for?
How many entries can mysql handle?
What is mysql and how it works?
How can you retrieve a particular number of records from a table?
Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.
How to delete an existing column in a table?
What is the hostname for mysql database?
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
Why to use char instead of varchar in the database?
What is ibdata1?
What do you need to connect php to mysql?
How many types of indexes are there in mysql?
How do I start mysql from command line?
How to use sum function in where clause in mysql?
What is difference between statement and preparedstatement?
