What is the difference between GROUP BY and ORDER BY in
Sql?
Answer Posted / jamsheed
Order by keyword is used to sort the result set in asc & desc order.
Group by keyword is used to group the resultset. It is used to find distinct values also.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is a tinyint in mysql?
What is mysql community edition?
How to shutdown mysql server?
Can you tell what are various ways to create an index?
What is the query to display top 20 rows?
What is the function of mysqldump?
How do I start mysql database?
What is difference between mysqli and pdo?
How to check if value already exists in mysql database in php?
Why phpmyadmin is used for mysql?
What are the 'mysql' command line arguments?
How can I insert images into a Mysql database?
What is mysql architecture?
Why are function needed?
What are the differences between char and varchar data types?