select * from (select A.*, rownum rn from T_CD_LOC A where rownum > 20) where rn <41 錯
select * from (select t.* ,rownum rn from T_CD_LOC t where rownum<=40) where rn>=20 對
firstIndex=0
pageNumber
pageSize=20
select * from (select A.*,rownum rn from T_CD_LOC a where rownum < ((firstIndex+pageNumber+1)*pageSize) where rn >((firstIndex+pageNumber)*pageSize)