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


Please Help Members By Posting Answers For Below Questions

What is where clause in sql?

535


What mean sql?

583


what is a view? : Sql dba

636


what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

621


What is the use of sqldataadapter?

536






what is the use of friend function? : Sql dba

543


What does pl sql stand for?

657


How do I start sql from command line?

535


Explain what is a subquery ?

656


How can one get sql*loader to commit only at the end of the load file? : aql loader

570


What is linq to sql?

554


Can dml statements be used in pl/sql?

579


what is the difference between primary key and unique key? : Sql dba

531


What is lookup table in sql?

605


what is 'mysqlshow'? : Sql dba

589