sqlserver分页的写法
Sql代码 www.2cto.com
SELECT
*
FROM
(
SELECT
TOP 20 *
FROM
(
SELECT
TOP(20 * 4)*
FROM
(SELECT cDwbh, cDwmc FROM kh)AS xxx
ORDER BY
cdwmc ASC
)AS t1
ORDER BY
cdwmc DESC
)AS t2
ORDER BY
cdwmc ASC;