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 { 15157 }

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 { TCS, 23905 }

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