SQL Statement to fetch sum salary for employees

Question

Can someone help me to form SQL Statement to fetch sum(salary) for employees department wise in tableau?. I don't know SQL?

Answer 1

Hi Preeti,

Try this,

SELECT DEPARTMENT, SUM(SALARY) FROM EMPLOYEES GROUP BY DEPARTMENT.

Hope it works!