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 is timestamp in mysql? : Sql dba

1132

What is a sql statement?

1018

What is a database trigger?

1136

How to return multiple rows from the stored procedure?

1015

Can we insert in view in sql?

1106

What are the subsets of sql?

1196

what is the different between now() and current_date()? : Sql dba

1075

What is the difference between a query and a report?

1056

What is meant by cursor in sql?

1062

Why do we create stored procedures & functions in pl/sql and how are they different?

995

What are sql ddl commands?

1137

What are the indexing methods?

1098

Explain the difference between sql and mysql.

1113

What are the differences between in and exists clause?

1166

What is trigger explain with example?

1092