Question

What is the purpose of the following clauses in a select statement?

i) ORDER BY
ii) GROUP BY

Answer 1

i) ORDER BY - ORDER BY clause is used to display data in an ordered form with respect to a specified column. By default, ORDER BY displays records in ascending order of the specified column’s values.

ii) GROUP BY - At times we need to fetch a group of rows on the basis of common values in a column. This can be done using a group by clause. It groups the rows together that contains the same values in a specified column.