It will only return 1 row per country and will display only the city that i

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

Question Posted / rod sohrabi

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

Please Help Members By Posting Answers For Below Questions

What are the column comparisons operators?

1297

What is dirty read and phantom read?

939

What is difference between unix timestamp and mysql timestamp?

1060

What is pdo connection?

929

What's the difference between mysql and sql server?

1037

What is a transaction? Describe mysql transaction properties.

1160

Why is the basic difference between left join, right join and inner join?

1069

What is logs in mysql?

950

What is the data type for file in mysql?

1028

What are the two types of queries?

1028

What is database url for mysql?

1025

How is mysql database stored?

1116

Is mysql a database?

993

How do I run mysql?

1089

How to write date and time literals?

1076