select * from (select rownum,name from table where rownum <=endIndex ) where rownum > startIndex --该片段来自于http://www.codesnippet.cn/detail/15112012362.html
来源: http://www.codesnippet.cn/detail/15112012362.html