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 is pl sql in dbms?

949

What does an inner join do?

1180

What is oracle pl sql developer?

981

How is indexing done in search engines?

982

How can I change database name in sql?

1083

How do you remove duplicates without using distinct in sql?

976

How do you run a query?

989

How many sql commands are there?

1114

What is a recursive stored procedure?

1183

What are the advantages of sql?

1055

What are operators available in sql?

1046

Does truncate need commit?

944

What is a sql instance vs database?

1114

Why do we go for stored procedures?

1057

How do you identify a primary key?

1063