I have a Employee table with columns
ename,eid,salary,deptno. How to retrieve sum of salary for
each deptno?
- 8 Answers
- 14372 Views
- L&T, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What is group function in sql?
what are the performance and scalability characteristics of mysql? : Sql dba
What is the difference between delete, truncate and drop command?
What port does sql server use?
Why is %isopen always false for an implicit cursor?
What is an intersect?
what is column? : Sql dba
Which is faster view or stored procedure?
How do I clear the screen in sql plus?
What are predefined functions in sql?
Can we call a function containing dml statements in a select query?
Is pl sql and postgresql same?
what are the differences between char and nchar? : Sql dba
how to shut down the server with 'mysqladmin'? : Sql dba
What does fetching a cursor do?
