取得前九条之后的数据
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
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