ROLLUP GROUPING CUBE
These are the enhancements to the group by feature.
- This will give the salaries in each department in each job category along wih the total salary for individual departments and the total salary of all the departments. Continue reading
GROUP BY AND HAVING
Using group by, we can create groups of related information.
Columns used in select must be used with group by, otherwise it was not a group by expression. Continue reading