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

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

Question Posted / prajakta

Answer Posted / prajakta

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

Is This Answer Correct ?

21 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How does php communicate with mysql?

956

Is mysql open source?

1020

What is an index? How can an index be declared in mysql?

936

How do I rename a procedure?

922

Which datatype is used for email in mysql?

1005

What is mysql architecture?

1073

What does mysql flush hosts do?

957

How to drop an existing view in mysql?

970

How do I restore a database in mysql workbench?

1075

What does mysqli stand for?

993

How can I see mysql database?

953

How to validate email addresses in mysql?

1178

Where is mysql data stored?

939

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

979

What is the return type of mysqli_query?

922