select deptno,sum(sal) from employee group by deptno;

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

Question Posted / kavithanedigunta

Answer Posted / kavithanedigunta

select deptno,sum(sal) from employee
group by deptno;

Is This Answer Correct ?

72 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Is it possible to include an insert statement on the same table to which the trigger is assigned?

998

What is an alias command?

1038

Can I create table without primary key?

981

What is a null value?

1124

what are the 'mysql' command line options? : Sql dba

1057

What are tables and fields in the database?

1092

what is acid property in database? : Sql dba

1008

which types of join is used in sql widely? : Sql dba

966

How does pl sql work?

947

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1051

Can we debug stored procedure?

1010

Why do we use joins in sql?

956

Is left join faster than inner join?

1105

what does the t-sql command ident_current does? : Transact sql

964

Can you select everything, but 1 or 2 fields, without writer's cramp?

970