SQL2005:
@pageIndex为当前页码,每页10条记录。
SELECT TOP 10 *
FROM
(
SELECT *,ROW_NUMBER() OVER (ORDER BY NewsID) AS RowNo
FROM T_News
) AS A
WHERE RowNo > (@pageIndex-1)*10
FROM
(
SELECT *,ROW_NUMBER() OVER (ORDER BY NewsID) AS RowNo
FROM T_News
) AS A
WHERE RowNo > (@pageIndex-1)*10
SQL2000:
pageIndex为当前页码,每页10条记录。
string sqlStr = "Select top 10 * From T_News
Where NewsID not in (Select top "+(pageIndex-1)*10+" NewsID From T_News Order by NewsID Asc)
Order by NewsID Asc";
Where NewsID not in (Select top "+(pageIndex-1)*10+" NewsID From T_News Order by NewsID Asc)
Order by NewsID Asc";