I have a Employee table with columns
ename,eid,salary,deptno. How to retrieve sum of salary for
each deptno?
Answer Posted / radheshyam mali
Select sum(salary) from Employee group by deptno
| Is This Answer Correct ? | 6 Yes | 10 No |
Post New Answer View All Answers
how can we know the number of days between two given dates using mysql? : Sql dba
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
How many types of functions are there in sql?
What are the different types of dbmss?
What is the largest value that can be stored in a byte data field?
Why is a primary key important?
Explain the the update statement in sql?
What are two statement types in sql?
What is the difference between having clause and where clause?
What jobs use sql?
how to dump a table to a file with 'mysqldump'? : Sql dba
Explain table and field in sql?
What is an emotional trigger?
What is the use of nvl function?
Is pl sql useful?