Here’s an interview question; asked in many interviews. The question: Write SQL query to find Salaries paid department-wise. You can get salaries paid to employees for each of the department codes from the EMPLOYEE table.
Read: 5 SQL MCQ Questions, Useful for Interviews As Well
Get Table Details
Take a look at this table by using the describe table command (DESC EMPLOYEE) or by using a full select statement (SELECT * FROM EMPLOYEE).
You can get the department code for an employee from the workdept column for the table and the relevant salary from the salary column of the same row.
Read: How to Derive Year from DATEs Useful MySQL Query
How to Write SQL Query
For arriving department-wise salary, you can use the SUM function. How do you tell the SUM function that you want different sums for each of the department codes?
Easy: you can tell by using work dept in GROUP BY. That’s the purpose of the group by clause.
Read: Join Three Tables with WHERE Here is Useful SQL Query
select workdept, sum(salary) as newsalary
from employee
group by workdept
WORKDEPT NEWSALARY
D11 646620.00
A00 354250.00
B01 94250.00
E11 317140.00
4 record(s) selected.
Get new content delivered directly to your inbox.