Tell me Dept wise average salary?

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

Read Online Database Management Job Interview Questions And Answers