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

explain primary keys and auto increment fields in mysql : sql dba

983

List the ways to get the count of records in a table?

903

How can we find duplicate records in a table?

952

What is error ora-01000: maximum open cursors exceeded

1154

What is pivot query?

1082

What is graph sql?

998

How do I get sql certification?

979

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

977

What is row_number () in sql?

990

Will truncate release space?

959

How do I find duplicates in sql?

940

how to fetch alternate records from a table? : Sql dba

1122

Why is theta join required?

1149

How do I view a sql trace file?

1037

What is a record in pl/sql?

1157