What is difference between group by and order by clause?
Answer / Om Prakash Divakar
The GROUP BY clause in SQL is used to group rows that have the same values, while the ORDER BY clause is used to sort the results. The GROUP BY clause comes after the WHERE and HAVING clauses, if used, and before the ORDER BY clause.
| Is This Answer Correct ? | 0 Yes | 0 No |
How would concatenate strings in mysql?
Is mysql a dbms?
What is longblob?
How do you control the max size of a HEAP table?
How to use 'mysql' to run sql statements?
How can we run batch mode in mysql?
Can mysql store files?
How do I disable mysql?
How would you get the current date in mysql?
What is difference between statement and preparedstatement?
What are the benefits of mysql?
how you will Create a database on the mysql server with unix shell.
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)