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

What is a ddl command?

1156

How do I save a sql query?

1067

What is compilation error in pl sql?

1025

What schema means?

939

Does user triggers have entry for trigger with compilation errors?

1091

What is vector point function?

1094

What can I use instead of union in sql?

1022

What is pl sql commands?

1097

What is db journal file?

1155

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

1013

What are stuff and replace function?

1141

How long will it take to learn pl sql?

981

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1067

Is record in oracle pl sql?

1017

What is set transaction?

1090