MSSQLÖÐÈçºÎÑ¡ÔñÒ»ÐÐÖÐ×îСµÄʱ¼ä£¿

Ò»ÕÅ±í£¬×ֶηÖΪid,time1,time2,time3,time4,time5 

ÇëÎÊÎÒÓ¦¸ÃÈçºÎÑ¡ÔñIDΪ1µÄÄÇÌõ¼Ç¼ÖÐtimeʱ¼ä×îСµÄÖµÄØ£¿

---

UP!

---

[code=SQL][/code]select min(t) from 
(select time1 as t from t1 where id=1 union all
select time2 as t from t1 where id=1 union all
select time3 as t from t1 where id=1 union all
select time4 as t from t1 where id=1 union all
select time5 as t from t1 where id=1 ) as tb

---

[code=SQL][/code] select min(t) from 
(select time1 as t from t1 where id=1 union all
select time2 as t from t1 where id=1 union all
select time3 as t from t1 where id=1 union all
select time4 as t from t1 where id=1 union all
select time5 as t from t1 where id=1 ) as tb

---

Óö¯Ì¬Á¬½ÓÒ»ÏÂ×Ö·û´®

---

ÔΡ£¡£¡£Õâô¶àµÄSQLÓï¾ä°¡¡£¡£ÄÇÖ´ÐÐÆðÀ´Ëù»¨µÄʱºòÊDz»ÊǺܶడ¡£¡£¡£

---

SQL code:
----------------------------------------------------------------
-- Author :SQL77(ֻΪ˼ÆëÀÏ)
-- Date :2010-01-26 19:29:35
-- Version:
-- Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
-- Aug 6 2000 00:57:48
-- Copyright (c) 1988-2000 Microsoft Corporation
-- Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 3)
--
----------------------------------------------------------------
--> ²âÊÔÊý¾Ý£º#TB
if object_id('TB') is not null drop table TB
go
cr