What is the difference between GROUP BY and ORDER BY in
Sql?
- 12 Answers
- 74552 Views
- Creative, Renault Nissan, Trikon Networks, I also Faced
- E-Mail Answers
Answer Posted / hareesha k
GROUP BY is used to group values from a column, and, if
necessary, perform calculations on that column. We can use
aggregation functions (e.g. COUNT, SUM, AVG) on the grouped
column.
The result of the GROUP BY is ordered by the column that
grouped.
The ORDER BY clause is used only for ordering(Sorting) the
query results.Asc by default.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to drop an existing table in mysql?
Do I need to pay for mysql?
What are date and time data types in mysql?
Why we use mysqli instead of mysql?
What is back end and front end?
How triggers can be used in mysql?
what are the different tables present in mysql? : Mysql dba
How to update database permissions/privilages.
How many threads can mysql handle?
What is the default port number of mysql?
What is logs in mysql?
Is mysql is a programming language?
How to use rank function in mysql?
What is the phantom problem?
What is mysql_query?
