Question

Explain Order by and Group by functions.

Answer 1

Answer:

1. Group by statement is used to group the rows that have the same value. Whereas Order by statement sort the result-set either in ascending or in descending order. ... Attribute cannot be in the group by statement under aggregate function. Whereas in order by statement, attribute can be under aggregate function.

Explanation:

hope ur help this answer ☺️

Answer 2

Answer:

Group by statement is used to group the rows that have the same value. Whereas Order by statement sort the result-set either in ascending or in descending order. ... While in select statement, it is always used after the group by keyword. 4. Attribute cannot be in the group by statement under aggregate function.