What is the purpose of ORDER BY clause in MySQL? How is it different from GROUP BY clause?
Answers
Answered by
12
To sort the result set, you use theORDER BY clause. The ORDER BY clause allows you to: Sort a result set by a single column or multiple columns. Sort a result set by different columns in ascending or descending order.
The GROUP BY Clause is used to group rows with same values . The GROUP BY Clause is used together with the SQL SELECT statement. The SELECT statement used in the GROUP BY clause can only be used contain column names, aggregate functions, constants and expressions.
reffered from Google.. hope this answer helps you... pls mark as brainliest
The GROUP BY Clause is used to group rows with same values . The GROUP BY Clause is used together with the SQL SELECT statement. The SELECT statement used in the GROUP BY clause can only be used contain column names, aggregate functions, constants and expressions.
reffered from Google.. hope this answer helps you... pls mark as brainliest
Similar questions