what is the difference between GROUP BY and ORDER BY in sql

user_149045 0
Viewed 278800

When do you use which in general? Examples are highly encouraged!

I am referring so MySql, but can't imagine the concept being different on another DBMS

mysql sql database
10 Answers

ORDER BY shows a field in ascending or descending order. While GROUP BY shows same fieldnames, id's etc in only one output.

user_13120460
Related