帮帮我啊,兄弟们.

[zhucp]

表 Table 字段：
Name ID
A 1
B 2
C 4
D 6
E 7
F 8

问题：如何从这个表中取出最小的 没有初使用的ID
如下面则，应该是 3 ，我如何写这条SQL 语句呢？？

[koposo]

select top 1( ID-1) from ttt where ID-1 not in(select ID from 表) and ID>1

[vinsonshen]

select c.new_id+1 as min_id from (
select isnull(min(a.id),max(a.id)) as new_id from (select id from 表) as a
left join (select min(id) as id2 from 表 union all select max(id) as id2 from test2) as b on a.id=b.id2
where b.id2 is null and not exists (select * from #test where id=a.id+1)) as c

[onetop]

SELECT ISNULL(MAX(c.ID), 0) + 1 AS MinID
FROM (SELECT (SELECT COUNT(*)
FROM aaa b
WHERE a.id >= b.id) AS ID, Name
FROM AAA a) c INNER JOIN
AAA d ON c.ID = d.id AND c.Name = d.Name


AAA 为Talbe名，最后得到的MINID就是 结果3

在SQLSERVER环境下运行通过。