SELECT deptno,SUM(sal) FROM emp GROUP BY deptno

I have a Employee table with columns
ename,eid,salary,deptno. How to retrieve sum of salary for
each deptno?

Question Posted / vikneswaran

Answer Posted / vikneswaran

SELECT deptno,SUM(sal) FROM emp
GROUP BY deptno

Is This Answer Correct ?

12 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is constant in pl sql?

969

What does partition by mean in sql?

909

what is commit? : Sql dba

1029

what are the advantages and disadvantages of views in a database? : Sql dba

996

Explain the difference in execution of triggers and stored procedures?

969

Why do we need sharding?

939

Are null values same as that of zero or a blank space?

969

What are different sql data types?

958

What is java sql drivermanager?

1023

Which is better varchar or nvarchar?

933

how can we know the number of days between two given dates using mysql? : Sql dba

993

what are the type of locks ? : Sql dba

901

How we can update the view?

1007

What is synchronized subquery?

1093

How do I start sql profiler?

943