I have a Employee table with columns
ename,eid,salary,deptno. How to retrieve sum of salary for
each deptno?

Answer Posted / rs

its right first one

Is This Answer Correct ?    9 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

discuss about myisam key cache. : Sql dba

565


What is oracle and pl sql?

664


Which language is used in sql?

525


How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

910


Can we call stored procedure in function?

557






Can we edit a view in sql?

555


What are different types of keys?

526


Why is a primary key important?

547


Is sql a case sensitive language?

521


What does count (*) mean in sql?

1095


what are the different index configurations a table can have? : Sql dba

577


Define implicit and explicit cursors.

633


What is nvl?

617


How to make a copy values from one column to another in sql?

580


What is a mutating table and a constraining table?

575