What is the difference between GROUP BY and ORDER BY in
Sql?
- 12 Answers
- 74652 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
I want to start and stop mysql on windows? How do I do that?
How to use rank function in mysql?
What is the function of mysqldump?
Is mysqli faster than mysql?
How to use sum function in where clause in mysql?
Where’s database data actually stored? Is there a way to see the files which are stored?
What is a simple query?
How to get the number of rows selected or affected by a sql statement?
How many columns can a table have?
Is mysql workbench a dbms?
Explain the architecture models of SQL Server?
List some comparisons operators used in mysql?
What are the difference between mongodb and mysql?
Explain the difference between mysql_fetch_array(), mysql_fetch_object()?
Can you tell few best practices to be followed for optimization in sql?
