sqlserver/sql语句
这里面的字段值是可重复的(上面是用分组查询出的没重复的结果),但是没有连续,我想找到缺少了哪些数字,用纯sql实现的,函数的已经有了,谢谢各位了 SQL sqlserver 连续 数字连续 sql语句
[解决办法]
;with t as
(
select 1 id
union all select 2
union all select 3
union all select 4
union all select 5
union all select 6
union all select 9
union all select 11
union all select 12
)
select a.number
from master..spt_values a
left join t on a.number=t.id
where a.type='p' and t.id is null
and a.number between (select min(id) from t) and (select max(id) from t)