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 is general log in mysql?

916

Should I use pdo or mysqli?

853

Why mongodb is faster than mysql?

838

What is mysql connection limit?

886

Why use stored procedures in mysql?

918

what are the different tables present in mysql? : Mysql dba

932

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

878

Which is faster mysql or mongodb?

868

How can I connect mysql database?

853

What are mysql data types?

950

Do I need python for mysql?

869

What are the disadvantages of stored procedures?

919

What is delimiter in mysql stored procedure?

861

Is mysql open source?

862

How do I start mysql in linux?

848