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

Categories >> Software >> Databases >> MySQL
Suggest New Category

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

Question Posted / nitin

5 Answers
9017 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / prajakta

this is right coz here order by clause is at the end of
query...

Is This Answer Correct ?

21 Yes

3 No

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

Answer / nitin

is right or not

Is This Answer Correct ?

18 Yes

4 No

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

Answer / manoj pandey

This is wrong because there is no aggregate function in the
query when a group by clause is used.

The above query could be like:

1. SELECT country, count(city)
2. FROM customers
3. GROUP BY country
4. ORDER BY country DESC

* Correction at line 1 & 4.

Is This Answer Correct ?

12 Yes

9 No

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

Answer / 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

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

Answer / vardhan rao

This Query will delete the duplicate values in GROUP BY clause

Is This Answer Correct ?

3 Yes

5 No

Post New Answer