取得前九条之后的数据

select Page,Result
from ( SELECT
*,row_number() over(order by result desc) as rownum FROM B_Record_DomainNamePage WHERE DomainName=@domainname and Type=@type and RecordDate=@estr) as a
where rownum>9

原文地址:https://www.cnblogs.com/whlhaikuotiankong/p/1985817.html