SELECTTOP10* FROM ( SELECT*,ROW_NUMBER() OVER (ORDERBY 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";