Question

what is the use of order by and group by clause in python. explain with example.
​

Answer 1

Answer:

Hello mate

Explanation:

ORDER BY is used to sort a result by a list of columns or expressions. GROUP BY is used to create unique combinations of a list of columns

Answer 2

Answer:

Group by statement is used to group the rows that have the same value. It is often used with aggregate functions for example:AVG(), MAX(), COUNT(), MIN() etc.