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 is the unique index?

1002

In what condition is it good to disable a trigger?

967

How do you use a while loop in pl sql?

939

What is the cause of mutating table error and how can we solve it?

992

What is the difference between cross join and natural join?

959

What is the difference between instead of trigger and after trigger?

947

What is package in pl sql?

961

what is union, minus and interact commands? : Sql dba

1120

What is pls_integer in pl sql?

1029

How to return multiple rows from the stored procedure?

912

What is indexes?

999

Is sql considered coding?

993

Can a foreign key be null?

1029

What is cte?

923

What are the two parts of design view?

973