@"SELECT *
FROM( SELECT ROW_NUMBER()OVER(ORDER BY ID ASC) AS RowNumber,*
FROM GoodSpec ) AS TEMPTABLE
WHERE RowNumber >@pageSize*(@curentPage-1) AND RowNumber<@pageSize*@curentpage;";
本人多次用到 希望能够有用
