最小時間と最大時間のSQL Server文の取得

364 ワード

SQL文
SELECT MIN(StartTime),MAX(StopTime) FROM (
(SELECT StartTime,StopTime,SUM(broken) OVER (ORDER BY StartTime,StopTime) flag
FROM (SELECT T.*,
(CASE WHEN StartTime <= MAX(StopTime) OVER (ORDER BY StartTime,StopTime ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING) THEN 0 ELSE 1 END) AS broken
FROM tableName T) T1) )T2 
GROUP BY flag