Interested to Buy Any Domain ? << Click Here >> for more details...
SELECT country,city
FROM customers
GROUP BY country
ORDER BY city DESC
- 5 Answers
- 11248 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How can you count the total number of records of any table?
What is an example of a delimiter?
What is a transaction? Describe mysql transaction properties.
How to load data files into tables with 'mysqlimport'?
How do I view mysql logs?
How do I delete a row in mysql?
What is the full form of mysql?
How do I disconnect mysql workbench?
How do I start mysql in mysql workbench?
What is mysql server used for?
What do ddl, dml, and dcl stand for?
How can I remotely connect to mysql database?
What is mysql community server?
How to find second highest salary from a table?
Can you tell what are various ways to create an index?
