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