摘要:
第一种方法,我的原创方法row=2 表示分页行数page=1 表示页码getnum=row*pageselect * from (select toprow * from (select topgetnum * from Newslist order by id desc) order by id asc) order by id descSQL查找第n条记录的方法:select top1 * from table where id not in (select top n-1 id from table)例如:select top 1 * from Evaluation where id n 阅读全文