Simple GROUP BY

Contact Us or call 1-877-932-8228
Simple GROUP BY

Simple GROUP BY

Code Sample:

Enhancing-Groups-With-Rollup-and-Cube/Demos/group_by.sql
SELECT 
	region_name, 
	country_name,  
	count(*) 
FROM emp_details_view 
GROUP BY region_name, country_name
ORDER BY region_name, country_name;

The initial query includes two columns that are grouped using the count analytic function.

Next