分页SQL语句

 

SELECT TOP 10 yhjc
 FROM 
        (
        SELECT ROW_NUMBER() OVER (ORDER BY ajh,yh) AS RowNumber,ml.yhm, yhjc FROM ML left join YH on ml.yhm = yh.yhm where ajh = '67' 
        ) A
 WHERE RowNumber > 10*(1-1) 

 

 

 

第0页也管用