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
10791 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

More MySQL Interview Questions

How you will Show unique records.

0 Answers

What is difference between oracle sql and mysql?

0 Answers

Is mysql deprecated?

0 Answers

How do I disconnect mysql workbench?

0 Answers

The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?

4 Answers Afixi, GE,

What is view in mysql?

0 Answers

What is mysqlcommand?

0 Answers

How large can a mysql table be?

0 Answers

How to execute mysql query in php?

0 Answers

What is deterministic in mysql?

0 Answers

Should I use pdo or mysqli?

0 Answers

What is the maximum length of a table name, database name, and fieldname in MySQL?

3 Answers Accenture, Pioneer, TISL,

For more MySQL Interview Questions Click Here