本文主要是介绍sql2005 联查多表时自动ID段,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
select * from (SELECTrow_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
这篇关于sql2005 联查多表时自动ID段的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!