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
11058 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 to display nth highest salary from a table in a mysql query?

0 Answers

mysql> select * from store; +------+-------+-------+ | id | month | sales | +------+-------+-------+ | 1 | 1 | 100 | | 1 | 2 | 100 | | 1 | 3 | 200 | | 1 | 4 | 300 | | 1 | 5 | NULL | | 1 | 6 | 200 | | 1 | 7 | 800 | | 1 | 8 | 100 | | 1 | 9 | 240 | | 1 | 10 | 140 | | 1 | 11 | 400 | | 1 | 12 | 300 | | 2 | 1 | 300 | | 2 | 2 | 300 | | 2 | 3 | 300 | | 2 | 4 | 200 | | 2 | 5 | 200 | | 2 | 6 | 200 | | 2 | 7 | 100 | | 2 | 8 | 100 | | 2 | 9 | 300 | | 2 | 10 | 100 | | 2 | 11 | 150 | | 2 | 12 | 150 | +------+-------+-------+ this is my table. i need to display output like this. +------+----------+----------+----------+----------+ | id | quarter1 | quarter2 | quarter3 | quarter4 | +------+----------+----------+----------+----------+ | 1 | 400 | 500 | 1140 | 840 | | 2 | 900 | 600 | 500 | 400 | +------+----------+----------+----------+----------+ what single query i have to write for this. i tried this query and it displays like the below mysql> select id,sum(sales) as quarter1,(select sum(sales) from store where mont h>3 and month<7 ) as quarter2,(select sum(sales) from store where month>6 and mo nth<10)as quarter3 from store where month>0 and month<4 group by id; +------+----------+----------+----------+ | id | quarter1 | quarter2 | quarter3 | +------+----------+----------+----------+ | 1 | 400 | 1100 | 1640 | | 2 | 900 | 1100 | 1640 | +------+----------+----------+----------+ 2 rows in set (0.00 sec) tel me how to rectify it.

2 Answers

What is database migration in mysql?

0 Answers

What does mysql flush tables do?

0 Answers

how do i list constraints in my database by using sql server2000?

1 Answers

How do I free up space in mysql?

0 Answers

In PHPmysql language how can we update our previous information.when update form open then we get our previous information in textbox,checkbox,selct,radio button.How can we show the information in checkbox,select menu,radio button which is available in database?

0 Answers

What is the purpose of mysql database?

0 Answers

How can you filter the duplicate data while retrieving records from the table?

0 Answers

What is sqlyog?

0 Answers

how many fields can be updated using set in a mysql query?

1 Answers

date funciton

2 Answers

For more MySQL Interview Questions Click Here