SELECT deptno,SUM(sal) FROM emp 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 / vikneswaran

Answer Posted / vikneswaran

SELECT deptno,SUM(sal) FROM emp
GROUP BY deptno

Is This Answer Correct ?

12 Yes

2 No

Please Help Members By Posting Answers For Below Questions

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1006

which operator is used in query for pattern matching? : Sql dba

1009

What if we write return in procedure?

1431

How do I find duplicates in a single column in sql?

1022

What are the qualities of 2nf?

1039

How do you select unique values in sql?

1003

What is prepared statement in sql?

1056

How to get list of all tables from a database?

1160

What is embedded sql what are its advantages?

1044

what are the different type of sql's statements ? : Sql dba

926

what are date and time intervals? : Sql dba

1060

What are sql indexes?

1004

What are the benefits of triggers?

1174

Explain what is a view?

1066

How to combine two stored procedures in sql?

1238