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

Define tables and fields in a database

1146

What is trigger in sql?

1110

Is sql a oracle?

986

What are the advantages of stored procedure?

1011

What are the types of dbms?

982

What is pl sql script?

1038

Explain what is dbms?

1071

how to increment dates by 1 in mysql? : Sql dba

989

what is 'mysqlimport'? : Sql dba

1067

Explain ttitle and btitle.

1127

What is not equal in sql?

1137

Can a varchar be a primary key?

1018

What is the current version of sql?

1032

What is scalar function?

1060

what are the performance and scalability characteristics of mysql? : Sql dba

1009