What is the difference between GROUP BY and ORDER BY clause i... | Questions and Answer on competitive exams like GATE exam, entrance tests, fun games, and much more

What is the difference between GROUP BY and ORDER BY clause in SQL?

GROUP BY controls presentation of rows and ORDER BY controls presentation of columns for results of SELECT statement
GROUP BY controls presentation of columns and ORDER BY controls presentation of rows for results of SELECT statement
GROUP BY orders rows in query's return and ORDER BY orders columns in query's return
none