What is the difference between GROUP BY and ORDER BY in
Sql?
Answer Posted / niraj kumar
To sort a result, use an ORDER BY clause.
The most general way to satisfy a GROUP BY clause is to
scan the whole table and create a new temporary table where
all rows from each group are consecutive, and then use this
temporary table to discover groups and apply aggregate
functions (if any).
ORDER BY [col1],[col2],...[coln]; Tells DBMS according to
what columns it should sort the result. If two rows will
hawe the same value in col1 it will try to sort them
according to col2 and so on.
GROUP BY [col1],[col2],...[coln]; Tells DBMS to group
(aggregate) results with same value of column col1. You can
use COUNT(col1), SUM(col1), AVG(col1) with it, if you want
to count all items in group, sum all values or view
average.
Is This Answer Correct ? | 24 Yes | 7 No |
Post New Answer View All Answers
What is a query in mysql?
What is innodb mysql?
Explain timestamp?
What is new mysqli?
How do I connect to a database in mysql workbench?
How do I tune a mysql query?
What is mysql slow query?
How to create table show example
Why use stored procedures in mysql?
What does mysql flush hosts do?
What is the latest version of mysql?
What are the different column comparison operators in mysql?
How to list or view all databases from the mysql server.
Which is better mysql or microsoft sql?
What is unsigned in mysql?