SELECT Tbl_Emp.empname, Tbl_Emp.salary AS Amount, TBL_Dept.Deptname
FROM Tbl_Emp INNER JOIN
TBL_Dept ON Tbl_Emp.deptid = TBL_Dept.Deptid
order BY deptname desc
COMPUTE SUM(salary) BY deptname
Showing posts with label // Show the salary sum according to the dept wise. Show all posts
Showing posts with label // Show the salary sum according to the dept wise. Show all posts
Friday, March 12, 2010
Subscribe to:
Posts (Atom)