标签：sqlserver文章列表
-
sqlserver分页查询(分页查询的sql语句)
( SELECT ISNULL(MAX(id),0) FROM ( SELECT TOP 页大小*(页数-1) id FROM table1 ORDER BY id ) A )ORDER BY id方法3：适用于 SQL Server 2005SELECT TOP 页大小 * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY id) AS RowNumber,* FROM table1 ) AWHERE RowNumber >页大小*(...
