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 you optimize a stored procedure query?

1004

what does it mean to have quoted_identifier on? : Sql dba

1146

tell us something about heap tables. : Sql dba

1104

What is a temporal data type?

1055

What is the difference between clustered and non-clustered indexes?

1093

what are local and global variables and their differences? : Sql dba

1077

Can we use the cursor's to create the collection in PL/SQL?

1030

How to select unique records from a table?

1063

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1163

how to use myisamchk to check or repair myisam tables? : Sql dba

972

what are the properties and different types of sub-queries? : Sql dba

1036

Why function is used in sql?

952

What is the mutating table and constraining table?

1030

Explain the rollback statement?

1016

What are the main features of cursor?

1071