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
What is where clause in sql?
What mean sql?
what is a view? : Sql dba
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What is the use of sqldataadapter?
what is the use of friend function? : Sql dba
What does pl sql stand for?
How do I start sql from command line?
Explain what is a subquery ?
How can one get sql*loader to commit only at the end of the load file? : aql loader
What is linq to sql?
Can dml statements be used in pl/sql?
what is the difference between primary key and unique key? : Sql dba
What is lookup table in sql?
what is 'mysqlshow'? : Sql dba