WITH TEMP AS( 
SELECT *, ROW_NUMBER() OVER (order by proj_name,pdls_position) AS ROW  
FROM (...) a ) 
WITH F AS
(SELECT * FROM TEMP where ROW >= 10 AND ROW < 20)
select count(1) from f

------解决方案--------------------
探讨

to：aoyihuashao
 不是top这么简单，是用
 WITH TEMP AS(
 SELECT *, ROW_NUMBER() OVER (order by proj_name,pdls_position) AS ROW
 FROM (...) a )
 SELECT * FROM TEMP where ROW >= 10 AND ROW  < 20

 我想在这个语句中把总条数也一起查出来。