Tag Archives: having clause

Structured Query Language (SQL) – Using GROUP BY/ HAVING

Structured Query Language – Using Group By/ Having

The GROUP BY query is typically used with aggregates.

SELECT d.dept_name, d.location, count(e.emp_ID)

FROM department d, employee e

WHERE d.dept_id = e.dept_id

GROUP BY d.dept_name, d.location

Continue reading Structured Query Language (SQL) – Using GROUP BY/ HAVING

Advertisements