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

What is hot backup and how it can be taken ?

Explain the term entity set in dbms?

What is a form used for in a database?

What are the characteristics of database?

Does google have a database program?

I have a table which has lot of inserts, is it a good database design to create indexes on that table?

What is netlib for clipper?

What are the importance of database in banking?

Mention a query to add email validation to your database

What are different type of normalization?

What is the difference between a MESSAGEBOX and an ALERT ?

Why are databases so important?

For more Database Management Interview Questions Click Here