I have a Employee table with columns
ename,eid,salary,deptno. How to retrieve sum of salary for
each deptno?
- 8 Answers
- 14370 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / sudarsan
SELECT
DeptNo AS Department,
Count(DeptNo) AS Dept_Count,
Sum(Salary) AS Salary_DeptWise FROM Employee
GROUP BY DeptNo
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is big data nosql?
Are subqueries better than joins?
Why we use stored procedure instead of query?
Where do we use pl sql?
How do you explain an index?
What are the types of variables use in pl sql?
How many types of functions are there in sql?
What is the difference between joins?
What is rownum?
What do you mean by dbms? What are its different types?
What does pl sql stand for?
What is keys and its types?
What is difference sql and mysql?
explain the difference between delete , truncate and drop commands? : Sql dba
what are local and global variables and their differences? : Sql dba
