SQL: Select Count with Group By
November 14th, 2009 by jeremychoneSELECT department, COUNT(*) as "Number of employees" FROM employees WHERE salary > 25000 GROUP BY department
SELECT department, COUNT(*) as "Number of employees" FROM employees WHERE salary > 25000 GROUP BY department