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

how is exception handling handled in mysql? : Sql dba

1061

How do I filter in sql profiler?

985

What is crud stand for?

984

What is a string data type in sql?

1021

What is synonyms?

1038

Does truncate remove indexes?

1008

What is sql catalog?

999

How do I find duplicates in sql?

915

How to add, remove, modify users using sql?

1021

What is union and union all keyword in sql and what are their differences?

1084

how to extract a unit value from a date and time? : Sql dba

978

How do I view stored procedures?

957

What is the use of double ampersand (&&) in sql queries? Give an example

1122

What is fmtonly in sql?

1059

what is oracle database ? : Sql dba

1007