摘要:
取出sql表中第31到40条的记录(以自动增长ID为主键):Sql Server 下:方案1:select top 10 * from t where id not in (select top 30 id form t order by id) order by id;方案2:select top 10 * from t where id in (select top 40 id from t order by id) order by id desc;MySql 下:select * from t order by idlimit 30,10;Oracle 下:select * from 阅读全文
摘要:
... 阅读全文