Interested to Buy Any Domain ? << Click Here >> for more details...
I have a Employee table with columns
ename,eid,salary,deptno. How to retrieve sum of salary for
each deptno?
- 8 Answers
- 17169 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
Explain the steps needed to create the scheduled job?
What is the starting oracle error number? What is meant by forward declaration in functions?
Why do we use procedures in pl sql?
how to delete an existing column in a table? : Sql dba
What is an inconsistent dependency?
What are inner outer left and right joins in sql?
How do you define a foreign key?
what is the difference between clustered and non clustered index in sql? : Sql dba
Which is faster truncate or drop?
Which constraints we can use while creating database in sql?
What is cursor status?
When sql appeared?
Does truncate require commit?
What do you mean by query optimization?
What is trigger and types?
