Big Data with Spark - Flat 33% OFF Offer ends in
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 ;