關于多條資料中,在多條開始時間結束時間中取最大交集
資料如下
id | 開始時間 | 結束時間 |
---|---|---|
1 | 2017-03-14 | 2017-04-19 |
2 | 2016-01-19 | 2018-04-19 |
3 | 2017-04-19 | 2019-04-19 |
SQL
SELECT id,
(SELECT start_date FROM `test` WHERE end_date>CURDATE() ORDER BY start_date ASC LIMIT ) AS sTime,
(SELECT end_date FROM `test` WHERE end_date>CURDATE() ORDER BY end_date DESC LIMIT ) AS eTime
FROM test