Groupby : It is a way to sub-total your results,or perform
some other ‘aggregate’ functions on them.
e.g : select sum(salary)from salary Groupby employee name.
Orderby : It is a simply a way to sort your results. it display result in assending or dessending order.
e.g : select * from customer where column name=”value” orderby column name.