i want salaries of 2 tables

Question

I had 2 tables T1(employeeid,Employee Name,Department name )and T2(employee id,salaries) then i want department wise salaries...

Answer 1

Select DeptName, sum(salaries)
from
T1
inner join T2 on T1.empid=T2.empid
group by DeptName

please mark it as answer if it addresses the issue.

Answer 2

Hi, bala krishna

 

you can write below query....

 

select T1.d_name, sum(T2.salaries) from T1,T2 where T1.id=T2.id group by T1.d_name 

 

NOTE : d_name is department name

 

Happy Coding...

 

Thank you,

(Ravi D. Sangtani)