SELECT ContractName ,ContractNO, State,CreateDate FROM
(SELECT ContractName ,ContractNO,CreateDate, State,ROW_NUMBER() OVER (ORDER BY CreateDate DESC) AS RowNumber FROM dbo.MALL_Contract) T1
WHERE RowNumber BETWEEN 10 AND 20
转载于:https://www.cnblogs.com/heyiping/p/9994737.html