求三个日期的最小值

[qiuqingpo]

一张表有三个字段，都是日期格式

date1,date2,date3

我想得到所有的数据，并且每一行显示date1,date2,date3的最小值

如：date1,date2,date3,datemin

不知道怎么写，求各位大大支招。谢谢

[繁花尽流年]

case when date1<=date2 and date1<=date3 then date1 when date2<=date1 and date2<=date3 then date2 when date3<=date1 and date3<=date2 then date3 end datemin 把这段拼到select里去

[顺势而为1]

Select min(Date1),min(Date2),min(Date3) From 表

[听雨停了]

WITH cte AS (
SELECT '2017-02-02' AS date1,'2017-08-05' AS date2,'2017-06-08' AS date3
UNION ALL
SELECT '2017-09-02','2017-11-05','2016-12-08'
)
SELECT date1,
       date2,
       date3,
       mindate = (
           SELECT MAX(date1)
           FROM   (
                      SELECT date1 
                      UNION ALL 
                      SELECT date2 
                      UNION ALL 
                      SELECT date3
                  )T
       )
FROM   cte

date1      date2      date3      maxdate
---------- ---------- ---------- ----------
2017-02-02 2017-08-05 2017-06-08 2017-08-05
2017-09-02 2017-11-05 2016-12-08 2017-11-05

(2 行受影响)

[听雨停了]

WITH cte AS (
SELECT '2017-02-02' AS date1,'2017-08-05' AS date2,'2017-06-08' AS date3
UNION ALL
SELECT '2017-09-02','2017-11-05','2016-12-08'
)
SELECT date1,
       date2,
       date3,
       mindate = (
           SELECT min(date1)
           FROM   (
                      SELECT date1 
                      UNION ALL 
                      SELECT date2 
                      UNION ALL 
                      SELECT date3
                  )T
       )
FROM   cte

date1      date2      date3      mindate
---------- ---------- ---------- ----------
2017-02-02 2017-08-05 2017-06-08 2017-02-02
2017-09-02 2017-11-05 2016-12-08 2016-12-08

(2 行受影响)

上面取到最大值去了，不好意思

[二月十六]

http://www.cnblogs.com/lkvm114/archive/2011/03/29/1999086.html

[碧水幽幽泉]

引用 5 楼 sinat_28984567 的回复:

http://www.cnblogs.com/lkvm114/archive/2011/03/29/1999086.html

https://forum.csdn.net/PointForum/ui/scripts/csdn/Plugin/003/monkey/2.gif