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

Why do we go for stored procedures?

993

What does count (*) mean in sql?

1515

what is an alias command? : Sql dba

1006

What is the order of sql select?

985

Why is normalization important?

971

Explain what is a database?

1036

How to assign sql query results to pl sql variables?

991

Is json a nosql?

914

Which is faster joins or subqueries?

929

What are aggregate functions in sql?

1087

what are the limitations of identity column? : Transact sql

1047

how can I make a script that can be bi-language (supports english, german)? : Sql dba

941

how many tables will create when we create table, what are they? : Sql dba

1018

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

915

What is procedure explain with program?

949