使用sql语句写出分页语句
(每页条数)pagesize=20 (第几页)pagenum=5
select top 20 * from t_news where id not in(select top ((5-1)*20)id from t_news)
使用sql语句写出分页语句
(每页条数)pagesize=20 (第几页)pagenum=5
select top 20 * from t_news where id not in(select top ((5-1)*20)id from t_news)