select deptno,sum(sal) from employee group by deptno;

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

Question Posted / kavithanedigunta

Answer Posted / kavithanedigunta

select deptno,sum(sal) from employee
group by deptno;

Is This Answer Correct ?

72 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How are functions and procedures called in PL/SQL?

586

What is the use of partition by in sql?

514

explain advantages of innodb over myisam. : Sql dba

646

Is and as keyword in pl sql?

511

Explain clause in sql?

560

What is trigger types in sql?

531

Is nosql faster than sql?

540

Can we rollback delete command?

512

What is native sql query?

546

what is collation? : Sql dba

612

How to call a javascript function from pl sql?

559

what are date and time functions in mysql? : Sql dba

532

define sql update statement ? : Sql dba

570

What is compilation error in pl sql?

504

What is secondary key?

508