What is the difference between GROUP BY and ORDER BY in
Sql?
Answer Posted / haritharavi
Order by clause is used to sort the rows in ascending or
descending order.Group by clause is used to sort/group a
number of rows together so as to apply aggregate functions.
So order by is only to sort the records where as group by
is to sort and find aggregate functions of each group.
| Is This Answer Correct ? | 32 Yes | 5 No |
Post New Answer View All Answers
Can mysql and mariadb coexist?
What is a data directory?
What is pdo :: fetch_assoc?
What is the default port of mysql server?
What is the current root password of mysql?
What is mysql and mysqli?
List the different types of normalization?
Is mysql from oracle?
How many queries can mysql handle?
What are date and time data types?
How to increment dates by 1 in mysql?
How to create a new table in mysql?
How do I change directories in mysql?
What is indexing in mysql?
What is mysql enterprise edition?