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 are the types of records?

1003

What are schema-level triggers?

1116

What is crud diagram?

962

What is dialect in sql?

954

What is schema in sql example?

1199

How do you update f as m and m as f from the below table testtable?

1871

How can I get the number of records affected by a stored procedure?

1074

what is offset-fetch filter in tsql? : Transact sql

960

Can sql developer connect to db2?

1061

What is sql table?

978

What is the limitation on the block size of pl/sql?

1004

What is a loop in sql?

994

What is equi join in sql?

1094

When can we use the where clause and the having clause?

1035

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1062