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
Is mariadb nosql?
What is the need of merge statement?
What is the difference between mdf and ndf files?
Why join is faster than subquery?
What are the basic sql commands?
What is scalar and vector?
How do you optimize a query?
Is progress software supports to ( pl/sql )?
How many functions are there in sql?
What is the difference between microsoft access and sql server?
How insert into statements in sql?
Why query optimization is needed?
Can a table contain multiple primary key’s?
What is data type in database?
How to find 3rd highest salary of an employee from the employee table in sql?