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 to run sql commands in sql*plus?

1081

how to present a past time in hours, minutes and seconds? : Sql dba

946

How to call a javascript function from pl sql?

1071

What are sql injection vulnerabilities?

911

How can triggers be used for the table auditing?

1011

How many triggers can be applied on a table?

882

What is the difference between the implicit and explicit cursors?

994

What are all the different normalization?

979

What is execute immediate?

1007

What is $$ in sql?

943

what happens if you no create privilege in a database? : Sql dba

940

Explain sql data types?

1037

How do I run a pl sql procedure in sql developer?

916

tell us something about heap tables. : Sql dba

1049

What are the basic sql commands?

1039