1 SELECT
 2     * 
 3 FROM
 4     (
 5     SELECT
 6         *,
 7         ROW_NUMBER ( ) OVER ( ORDER BY Id DESC ) AS RowIndex 
 8     FROM
 9         (
10         SELECT
11             [p].[Sysno] AS [Sysno],
12             [p].[Productname] AS [ProductName],
13             [pr].[Productphotourl] AS [ProductPhotoUrl],
14             [p].[Typename] AS [TypeName],
15             [p].[Id] AS [Id] 
16         FROM
17             [Products] p,
18             [Productphotos] pr 
19         WHERE
20             ( [p].[Sysno] = [pr].[Sysno] ) 
21         ) MergeTable 
22     WHERE
23         ( [ProductName] LIKE '%五金%' AND [TypeName] LIKE '%产品%' ) 
24     ) T 
25 WHERE
26     RowIndex BETWEEN 1 
27     AND 5