select Row,title from (SELECT ROW_NUMBER() OVER (ORDER BY id) AS ROW,title from 表名)AS 表1 where ROW>=起始 and ROW<=结束;