---
select id1,(select min(id)-1 from table where id > id1) as id2 from (
select id+1 as id1 from table where id+1 not in (select id from table) and id < (select max(id) from table)
) as t1
還真好用!! 取區間號碼
邏輯等於0與1和ON與OFF,是程式創作的思維. 如何利用創作來支援生活面呢? 唯有.. 一直努力在程式領域上突破及更新自我;更是要有失敗的心情準備!! 聯絡方式 LINE ID : wushig (池龍工作室) 0931507058 巫先生
2015年1月30日 星期五
mssql 取區間號碼
參考來源
---
select id1,(select min(id)-1 from table where id > id1) as id2 from (
select id+1 as id1 from table where id+1 not in (select id from table) and id < (select max(id) from table)
) as t1
還真好用!! 取區間號碼
---
select id1,(select min(id)-1 from table where id > id1) as id2 from (
select id+1 as id1 from table where id+1 not in (select id from table) and id < (select max(id) from table)
) as t1
還真好用!! 取區間號碼
訂閱：
文章 (Atom)