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 pl sql block structure?

1015

What are sql objects?

1064

How long will it take to learn pl sql?

923

What is the difference between delete, truncate and drop command?

1126

What are the different types of constraints?

1151

Can a trigger call a stored procedure?

1050

What is pragma in sql?

1057

Where can I learn sql for free?

977

Explain the insert into statements in sql?

981

what is csv? : Sql dba

982

Why schema is used in sql?

1028

Define the select into statement.

1037

differentiate between float and double. : Sql dba

1036

what is online transaction processing (oltp)? : Sql dba

977

How do I truncate a sql log file?

1053