SQL2005/2008分页语句
SELECT * FROM ( SELECT ROW_NUMBER() OVER ( ORDER BY ConfigInfoId ) AS RowNumber, * FROM ConfigurationInfo ) AS A1 WHERE RowNumber BETWEEN 11 AND 20 ORDER BY ConfigInfoId
SELECT * FROM ( SELECT ROW_NUMBER() OVER ( ORDER BY ConfigInfoId ) AS RowNumber, * FROM ConfigurationInfo ) AS A1 WHERE RowNumber BETWEEN 11 AND 20 ORDER BY ConfigInfoId