Showing the list of department in sql.

Use following query :



SELECT dept_id,SUM(salary) FROM dept GROUP BY dept_id HAVING SUM(salary)>1500


if you want only department id list then use :


SELECT dept_id FROM dept GROUP BY dept_id HAVING SUM(salary)>1500



Mark this answer as accepted if it really helps you..!!