全部博文
-
编辑 删除
2013常用面试题(不断整理中..)(II)
50.分页语句 取出sql表中第31到40的记录（以自动增长ID为主键） sql server方案1： select top 10 * from t where id not in (select top 30 id from t order by id ) orde by id sql server方案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 id limit 30,10 oracle方案：select * from (select rownum r,* from t where r<=40) wher
