Select sum(salary) 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 / radheshyam mali

Answer Posted / radheshyam mali

Is This Answer Correct ?

6 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What are %type and %rowtype for?

1061

What are the differences between in and exists clause?

1121

What are predefined functions in sql?

1052

Does truncate release storage space?

1088

What are inbuilt functions in sql?

1071

What is a clob in sql?

1028

what is isam? : Sql dba

1019

what is text? : Sql dba

1076

Does mysql_real_escape_string prevent sql injection?

957

Which query operators in sql is used for pattern matching?

976

What is record type in pl sql?

1002

Why do we need cursor in pl sql?

1142

What are the basic techniques of indexing?

1072

Is sql microsoft?

1062

Why do we use triggers?

975