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 a logical backup ?

What is denormalization and why would someone consider doing so?

hello to all i want code for like this site "Submit Question" page.please give answers thanks.

what is GET_BLOCK property ?

Explain the concepts of a primary key and foreign key.

What is a distributed database?

What's the difference between 'union' and 'union all' ?

What do you understand by ‘database’?

what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000

What do you mean by deadlock dbms?

what are primary key and foreign key ?

What is the purpose of a database table?

For more Database Management Interview Questions Click Here