Interview Questions Answers in SQL PLSQL

anilkumar.p

{ City } hyderabad
< Country > india
* Profession * oracle apps technical consulta
User No # 101212

Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 1
Users Marked my Answers as Wrong # 1

Questions / { anilkumar.p }

Questions Answers Category Views Company eMail

Answers / { anilkumar.p }

Question { 16956 }

how to find 5th row ?

Answer

select * from emp where rownum <=5 minus
select * from emp where rownum <5

Is This Answer Correct ?

1 Yes

0 No

Question { IBM, 26944 }

select top 3 sal from each dept?

Answer

select * from(select ename,deptno,sal from emp order by sal desc) where rownum<=3

Is This Answer Correct ?

0 Yes

1 No