Enrollments Closing Soon for Online Instructor-Led DevOps Certification Training by CloudxLab | No Cost EMI Available

  Enroll Now

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.

%%sql

select sum(empsal) sum_sal,mgrempid from emp_<<your lab username>>
group by mgrempid
order by mgrempid
;

No hints are availble for this assesment

Answer is not availble for this assesment

Loading comments...