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
What is datadir?
Is mysql a relational database?
How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.
What is view? How can you create and drop view in mysql?
How many types of indexes are there in mysql?
Is pdo faster than mysqli?
What is difference between mysql and mysqli?
What is join in mysql? What are the different types of join?
How to dump one database for backup.
What is delimiter in mysql?
How to include character strings in sql statements?
What is general log in mysql?
What is the use of mysqli_query?
What is definer in mysql trigger?
How do you use auto increment?