\t\t\tBasicGroup By is used to form the Group of the set of the tuples.Order By is used to arrange the data obtained as a result of a query in Sorted form.AttributeAttribute under Aggregate function can not be in Group By clause.Attribute under aggregate can be in Order By Clause.GroundDone on the ground of similarity among attribute values.Done on the ground of ascending order and descending order.\t
1.

Differentiate between where and order by clause of select statement with example

Answer» Is where and group by same thing??
BASIS FOR COMPARISON GROUP BY ORDER BY


Discussion

No Comment Found

Related InterviewSolutions