Find sql salary

Question

There are two tables with the columns shown in brackets. a. Employee(emp_idemp_nameemp_salaryemp_dept_id) b.Department(dept_iddept_name) Write a SQL to show the total salary for each department

Rahul Bhatt · Answer

To achive this task make your query as folloiwng way Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:;mso-padding-alt:0cm 5.4pt 0cm 5.4pt;mso-para-margin-top:0cm;mso-para-margin-right:0cm;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0cm;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:Calibrisans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:Times New Roman;mso-bidi-theme-font:minor-bidi;mso-fareast-language:EN-US;} select TableB . dept_name  SUM ( TableA . emp_salary ) from Employee as TableA Inner join Department as TableB on TableA . emp_dept_id = TableB . dept_id Group by TableB . dept_name

Sudhakar Chaudhary · Answer

create database cor use cor create table employee(emp_id intemp_name varchar(50)emp_salary decimal(182)emp_dept_id int) select * from employee create table department(dept_id intdept_name varchar(50)) SELECT employee.emp_dept_id department.dept_namesum(employee.emp_salary)as Salary FROM department INNER JOIN employee ON department.dept_id = employee.emp_dept_id GROUP BY employee.emp_dept_iddepartment.dept_name

Suthish Nair · Answer

Using Inner Join join both tables based on column dept_id list the columns.