WITH AllRecords AS(SELECT t.SID,ROW_NUMBER() OVER (ORDER BY t.[Added] DESC) AS RowNumber,EntrustNo AS f1,t1.ProductName AS f2,t3.Caption AS f3,ProjictName AS f4,EntrustCompany AS f5,No3H AS f6,ReportNo AS f7,EntrustDate AS f8,case when SampleSave=0 then '否' else '是' end AS f9,LinkMan AS f10,ContactWay AS f11,t2.TestModelName AS f12,t.Remark AS f13,t.SetMan AS f14,t4.LoginName AS f15,t.Modified AS f16
FROM [QIEntrustInfo] t
INNER JOIN [QIProductType] t1 ON t.QIProductTypeSid=t1.SID
LEFT JOIN [PGUser] t4 ON t.ModifiedUserID=t4.SID
WHERE t.Deleted = 0)
SELECT * FROM AllRecords WHERE RowNumber > 0 AND RowNumber <=10
