要查数据表中第30到40条记录,有字段id,但是id并不连续。如何写sql语句?

方法1：

SELECT TOP 10 *

FROM

(

SELECT TOP 40 *

FROM dbo.Log

ORDER BY ID DESC

) T

ORDER BY T.ID ASC

方法2：

SELECT *

FROM

(

SELECT *, (ROW_NUMBER() OVER ( ORDER BY ID DESC ) )AS ROWNUMBER

FROM dbo.Log

) T

WHERE T.ROWNUMBER <= 40

AND T.ROWNUMBER > 30

liqunfeng2003的专栏