SELECT COUNT(EID) AS EMPLOYEE,DEPTNON,SUM(SALARY) FROM EMPLOYEE GROUP BY D

I have a Employee table with columns
ename,eid,salary,deptno. How to retrieve sum of salary for
each deptno?

Question Posted / madhusudan darshannkar

Answer Posted / madhusudan darshannkar

SELECT COUNT(EID) AS EMPLOYEE,DEPTNON,SUM(SALARY) FROM
EMPLOYEE GROUP BY DEPTNO

Is This Answer Correct ?

4 Yes

12 No

Please Help Members By Posting Answers For Below Questions

what are null values? : Sql dba

959

What is the most important ddl statements in sql are?

997

What is user in sql?

1027

What is normalization? How many normalization forms are there?

1089

What are the benefits of stored procedures?

1074

How to rename a column in the output of sql query?

1072

Which language is used in sql?

1065

What do you mean by stored procedures? How do we use it?

996

Why is there a need for sqlcode and sqlerrm variables?

1053

What are sql constraints?

1180

What is nosql vs sql?

1181

define sql delete statement ? : Sql dba

1024

Why query optimization is needed?

930

What are the advantages of indexing?

986

Explain exception handling in pl/sql?

1039