Enhance your Knowledge | Flat 25% Discount on all Courses | Use Coupon Code - ENHANCE25 During Checkout |

 Enroll Now

SQL Tutorial

28 / 60
   

Grouping on Aggregate Functions

Same Aggregate Functions are applied on grouped data. Grouping is done on the required columns of the table.

For example, you need to know manager wise sum of salaries of employees.

select sum(empsal) sum_sal,mgrempid from emp
group by mgrempid
order by mgrempid
;