select * from (SELECT
row_number() over(order by id desc) as rowid,
[id]
,[PureKeys]
,[PrintCount]
,[PrintState]
,[HostName]
,[Remark]
,[PrintUserID]
,[IsDoingLog]
,[CDateTime]
FROM [SHIFTCTSDATA].[dbo].[DBSPurePrintLog]) t
where t.rowid between 3 and 8
row_number() over(order by id desc) as rowid,
[id]
,[PureKeys]
,[PrintCount]
,[PrintState]
,[HostName]
,[Remark]
,[PrintUserID]
,[IsDoingLog]
,[CDateTime]
FROM [SHIFTCTSDATA].[dbo].[DBSPurePrintLog]) t
where t.rowid between 3 and 8