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


Please Help Members By Posting Answers For Below Questions

How do I copy a table in mysql?

488


How do I insert an image into mysql workbench?

478


How to control the max size of a heap table?

553


Is mysql open source?

486


What is cast in mysql?

478






Write a query to fetch duplicate records from a table using mysql?

506


What is a csv table?

549


Explain timestamp?

590


what is database white box testing? : Mysql dba

516


How do I rename a table in mysql?

502


What is difference between mysqli and pdo?

477


Can I use mariadb instead of mysql?

495


What is trigger in mysql with example?

497


In which year mysql created?

535


Explain the difference between procedure and function in mysql?

526