摘要: 取出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 阅读全文
posted @ 2013-08-13 17:46 残星 阅读(408) 评论(0) 推荐(0) 编辑
摘要: ... 阅读全文
posted @ 2013-08-13 16:37 残星 阅读(4469) 评论(0) 推荐(1) 编辑