帮我看下这个分页
SELECT top 60 t.rid,t.ProductID,t.ReCompanyID
FROM
(
SELECT rid=ROW_NUMBER() OVER(PARTITION BY P.ReCompanyID ORDER BY P.ProductDateTime DESC),c.CompanyName,
P.ProductID,P.ReCompanyID,P.ProductDateTime
FROM Product P, Company c
Where P.ProductType=3 and P.ReCompanyID=c.CompanyID
) AS T
WHERE T.rid<=2
and T.ProductID not in
(
SELECT top 600 a.ProductID
FROM
(
SELECT rid=ROW_NUMBER() OVER(PARTITION BY P.ReCompanyID ORDER BY P.ProductDateTime DESC),c.CompanyName,
P.ProductID,P.ReCompanyID,P.ProductDateTime
FROM Product P, Company c
Where P.ProductType=3 and P.ReCompanyID=c.CompanyID
) AS a
WHERE a.rid<=2
order by a.ReCompanyID Desc ,a.ProductDateTime Desc
)
order by T.ReCompanyID Desc ,T.ProductDateTime Desc
不过速度很慢(45万条数据,查询时间为1秒),哪位肯指点下。谢谢!