mahesh pawar


{ City } mumbai
< Country > india
* Profession *
User No # 58633
Total Questions Posted # 0
Total Answers Posted # 1

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

Users Marked my Answers as Correct # 8
Users Marked my Answers as Wrong # 2
Questions / { mahesh pawar }
Questions Answers Category Views Company eMail




Answers / { mahesh pawar }

Question { 2898 }

i need query for displaying the eno,ename in a table from row
2 to row 5


Answer

ans 1 -

select *
from (
select rownum num , empno, ename
from emp
)
where num between 2 and 5

------------------

we can also use row_number function

Is This Answer Correct ?    8 Yes 2 No