Dept wise avrage salary

Question Posted / chinna

Answers were Sorted based on User's Feedback

Dept wise avrage salary..

Answer / suraj

select deptno,trunc(avg(sal))as avg from emp group by deptno;

Is This Answer Correct ?

6 Yes

0 No

Dept wise avrage salary..

Answer / naresh

select avg(sal) from emp group by deptno;

Is This Answer Correct ?

1 Yes

0 No

More Database Management Interview Questions

How to do replication of firebird databases?

What are the different types of keys in database?

What is n tier architecture in dbms?

What are five main functions of a database administrator?

Why does reading require write privileges on database file?

Is it possible to Enable or Disable a Database trigger ?

What are procedures in database?

Where is data stored in a database?

What is alternate key?

Can the SNAPSHOTS be refreshed automatically ?

How data are stored in database?

How do you create a blank database?

For more Database Management Interview Questions Click Here