NEW INTERVIEW QUESTIONS.COM DATABASE INTERVIEW QUESTIONS SQL SERVER INTERVIEW QUESTIONS DETAILS

Add to My Questions | Forward | Print

Question

List sum(sal) for each department from emp table and dep table.

Answer

select sum(sal) from +sum(sal) from Answered By: naresh    Date: 2/19/2008 select sum(SAL)from department Answered By: raghavender    Date: 3/15/2008 select deptno,sum(sal) from dept group by deptno; Answered By: NarsimhaRao Mothkuri    Date: 3/15/2008 SELECT dep.department,sum(emp.sal) FROM dep INNER JOIN emp ON dep.department = emp.department group by dep.department Answered By: Binesh Das    Date: 3/19/2008 SELECT SUM(sal) from employee(table) GROUP BY DEPARTMENT(COLUMN) Answered By: bal krishan    Date: 6/8/2008 select A.deptName,sum(sal) from Employee A, Department B where A.DeptName=B.DeptName group by A.deptName Answered By: Anitha    Date: 6/17/2008 © NewInterviewQuestions.com

Answer:*
Name:*
Email Address:*
Verification Code	Not readable? Load New Code
Enter the above shown code:*

Category	SQL Server Interview Questions
Rating	(5.0) By 1 users
Added	1/1/2008
Views	1
Rate it!	* * * * * * * * * * * * * * *
Free Offers:	300 Free Magazines for you. No credit card required. No Shipping Charges. Absolutely Free for 1 Year.

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when answer is posted!
Email: