Database Management Question: Download Database Management PDF
Tell me Dept wise average salary?
Answer:
select deptno,trunc(avg(sal))as avg from emp group by deptno;
| Previous Question | Next Question |
| Do you know how to join two table? | What is the difference between inline query and corelated subquery? |