例: 有一数据表名为TABLE4,有一个ID的编号,现想找出不是连续的ID编号中最小的一个:/* 1 s 3 ss 5 vv 7 c 9 l */SELECT TOP 1 ID+1 FROM table4 AS aaa WHERE aaa.ID=(select count(*)+1 from table4 where aaa.ID>ID) ORDER BY aaa.ID DESC/* 结果: 2*/
SELECT MIN(用户号)+1 FROM A WHERE 用户号 NOT IN (SELECT 用户号-1 FROM A)
select min(id+1) from tb where (id+1) not in(select id from tb)
有一数据表名为TABLE4,有一个ID的编号,现想找出不是连续的ID编号中最小的一个:/*
1 s
3 ss
5 vv
7 c
9 l
*/SELECT TOP 1 ID+1
FROM table4 AS aaa
WHERE aaa.ID=(select count(*)+1 from table4 where aaa.ID>ID)
ORDER BY aaa.ID DESC/*
结果:
2*/
SELECT MIN(用户号)+1 FROM A WHERE 用户号 NOT IN (SELECT 用户号-1 FROM A)