I have a Employee table with columns
ename,eid,salary,deptno. How to retrieve sum of salary for
each deptno?
Answer Posted / kavithanedigunta
select deptno,sum(sal) from employee
group by deptno;
| Is This Answer Correct ? | 72 Yes | 4 No |
Post New Answer View All Answers
How to run sql commands in sql*plus?
how to present a past time in hours, minutes and seconds? : Sql dba
How to call a javascript function from pl sql?
What are sql injection vulnerabilities?
How can triggers be used for the table auditing?
How many triggers can be applied on a table?
What is the difference between the implicit and explicit cursors?
What are all the different normalization?
What is execute immediate?
What is $$ in sql?
what happens if you no create privilege in a database? : Sql dba
Explain sql data types?
How do I run a pl sql procedure in sql developer?
tell us something about heap tables. : Sql dba
What are the basic sql commands?