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 delimiter sql?

1060

What is the difference between database trigger and stored procedure?

1141

How do you declare a constant?

1018

explain primary keys and auto increment fields in mysql : sql dba

1017

How do I view output in sql developer?

1126

how tsql statements can be written and submitted to the database engine? : Transact sql

1037

What is a temporal table?

983

What is Histogram?

1611

Explain the update statement in sql

1046

What is nosql db?

1020

How many clustered indexes can you have?

1038

What is a natural join sql?

1040

What are sql injection vulnerabilities?

1027

Explain the advantages and disadvantages of stored procedure?

1199

When sql appeared?

1148