SELECT TOP 20 *
FROM (
SELECT ROW_NUMBER() OVER (ORDER BY 字段1 desc) AS RowNumber,* FROM(
SELECT 字段1 FROM 表
)subQuery
) A
WHERE RowNumber > 20*(1-1);
SELECT TOP 20 *
FROM (
SELECT ROW_NUMBER() OVER (ORDER BY 字段1 desc) AS RowNumber,* FROM(
SELECT 字段1 FROM 表
)subQuery
) A
WHERE RowNumber > 20*(1-1);