ROW_NUMBER()不能在where子句中,因此您必须使用单独的select:
select *from (select row_number() over (ORDER BY cars.CarId) as Row, * from cars ) tempwhere Row between 20 and 29

ROW_NUMBER()不能在where子句中,因此您必须使用单独的select:
select *from (select row_number() over (ORDER BY cars.CarId) as Row, * from cars ) tempwhere Row between 20 and 29