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

explain normalization concept? : Sql dba

1090

What are string functions in sql?

1305

How can we store rows in PL/SQL using array?

1269

What is the location of pre_defined_functions.

1209

what is 'mysqlimport'? : Sql dba

1112

What is a composite primary key?

1142

What is the difference between subquery and correlated query?

1117

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1116

What are the query optimization techniques?

1000

What is sql scripting?

1194

What is asqueryable?

1036

Enlist the advantages of sql.

1052

What is flag in sql?

1099

Why do we need sharding?

1049

What are variables in pl sql?

1234