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
How do I copy a table in mysql?
How do I insert an image into mysql workbench?
How to control the max size of a heap table?
Is mysql open source?
What is cast in mysql?
Write a query to fetch duplicate records from a table using mysql?
What is a csv table?
Explain timestamp?
what is database white box testing? : Mysql dba
How do I rename a table in mysql?
What is difference between mysqli and pdo?
Can I use mariadb instead of mysql?
What is trigger in mysql with example?
In which year mysql created?
Explain the difference between procedure and function in mysql?