select * from (select rownum,name from table where rownum <=endIndex )   
where rownum > startIndex