22,209
社区成员
发帖
与我相关
我的任务
分享
select min(工序)
from tb
where 工序 > 0010
------------------------------------------------------------------------
-- Author : HappyFlyStone
-- Date : 2010-10-07 11:12:21
-- Version: Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)
-- Mar 29 2009 10:27:29
-- Copyright (c) 1988-2008 Microsoft Corporation
-- Enterprise Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)
--
------------------------------------------------------------------------
-- Test Data: ta
IF OBJECT_ID('[ta]') IS NOT NULL
DROP TABLE [ta]
Go
CREATE TABLE ta([col] INT)
Go
INSERT INTO ta
SELECT 1 UNION ALL
SELECT 2 UNION ALL
SELECT 3 UNION ALL
SELECT 4 UNION ALL
SELECT 9 UNION ALL
SELECT 10 UNION ALL
SELECT 11 UNION ALL
SELECT 12 UNION ALL
SELECT 15 UNION ALL
SELECT 16
GO
--Start
select min(col)+1
from ta a
where not exists(select 1 from ta where a.col = col -1)
--Result:
/*
-----------
5
(1 行受影响)
*/
--End