select deptno,sum(sal) from employee 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 / kavithanedigunta

Answer Posted / kavithanedigunta

select deptno,sum(sal) from employee
group by deptno;

Is This Answer Correct ?

72 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How do I view a view in sql?

994

What is mutating table error?

1240

What is the use of desc in sql?

1022

What is scalar data type in pl sql?

1119

Is there any restriction on the use of union in embedded sql?

1199

Explain the components of sql?

1108

What are the types of variables use in pl sql?

1092

Can you load data into multiple tables at once? : aql loader

1118

what is rollback? : Sql dba

1181

How do I view a sql database?

1062

What is not null in sql?

1109

What is left join in sql?

1093

What is foreign key sql?

1040

What is an emotional trigger?

1057

what is not null constraint? : Sql dba

1078