SQL任意读取制定行

select * from (SELECT ROW_NUMBER() OVER(ORDER BY MSI.MINE_SURVEY_ID desc) ID ，* from 表）Data where ID>20000 and ID<=40000