SQL 2005 支持分页查询

发布时间:2014-10-25 2:19:59
来源:分享查询网

 CODE 如下: SELECT * FROM (select ROW_NUMBER() Over(order by TableName) as rowNum, * from Sales.TableName) as tablename where rowNum> 0 and rowNum<50

返回顶部
查看电脑版