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