instead of deptno the result will give u in department name select sum(s

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

Question Posted / lova raju allumalla

Answer Posted / lova raju allumalla

instead of deptno the result will give u in department name

select sum(sal),dname from emp e,dept d where
e.deptno=d.deptno group by dname
/

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Is pl sql different from sql?

536

What is user defined functions?

580

Does truncate need commit?

520

What is the non-clustered index in sql?

591

Is a view faster than a stored procedure?

550

What is pl/sql table? Why is it used?

565

Which is faster truncate or drop?

564

Does pl/sql support create command?

578

What is the max nvarchar size?

525

What is difference between pl and sql?

535

what is union, minus and interact commands? : Sql dba

668

What is a unique key?

588

Can you inner join the same table?

529

How can triggers be used for the table auditing?

596

What are actual parameters and formal parameters?

573