2013年11月30日
SQL顺序列找出断号
摘要： select id from infoid-----------123567810111215(11 行受影响)方法一：select (select max(id)+1 from Info where id(select max(id)+1 from Info where id beginId) as endIdfrom (select id+1 as beginId from info where id+1 not in (select id from info) and id < (select max(id) from info)) as tbeginId endId------- 阅读全文
posted @ 2013-11-30 18:02 yellowshorts 阅读(501) 评论(0) 推荐(0)