)c where rownum<=3000
) where rn >1500
应该改为
)
) where rn >1500 and rn<=3000
吧