select * from (
select *, ROW_NUMBER() OVER(Order by a.MonitorTime DESC ) AS RowNumber from V_T_Mid_HourData_IAQI as a
) as b
where RowNumber BETWEEN 1(起始行) and 100(结束行)
select *, ROW_NUMBER() OVER(Order by a.MonitorTime DESC ) AS RowNumber from V_T_Mid_HourData_IAQI as a
) as b
where RowNumber BETWEEN 1(起始行) and 100(结束行)