oracle 求连续日期的起始日期和终止日期

最新推荐文章于 2023-11-27 15:23:56 发布

304的的哥

最新推荐文章于 2023-11-27 15:23:56 发布

阅读量2.8k

点赞数

分类专栏： Oracle PL/SQL编程文章标签： oracle date

本文链接：https://blog.csdn.net/chen_linbo/article/details/6523969

版权

Oracle PL/SQL编程专栏收录该内容

103 篇文章 0 订阅

订阅专栏

//数据 1 2011-2-1 1 2011-2-2 1 2011-2-3 1 2011-2-11 1 2011-2-12 1 2011-2-13 //结果 1 2001-2-1 2011-2-3 1 2011-3-11 2011-2-13 //解法： with t as ( select 1 id, date'2011-2-1' mydate from dual union all select 1 id, date'2011-2-2' mydate from dual union all select 1 id, date'2011-2-3' mydate from dual union all select 1 id, date'2011-2-11' mydate from dual union all select 1 id, date'2011-2-12' mydate from dual union all select 1 id, date'2011-2-13' mydate from dual) SELECT id, MIN(mydate), MAX(mydate) FROM t START WITH NOT EXISTS (SELECT 1 FROM t b WHERE b.mydate = t.mydate - 1) CONNECT BY PRIOR t.mydate = t.mydate - 1 GROUP BY rownum - LEVEL, id;

原帖：

http://topic.csdn.net/u/20110602/09/02d22133-5427-4758-90fd-4f1519679994.html?95544

关于start with connect by:

[1]http://psoug.org/reference/connectby.html

[2]http://blog.csdn.net/BOBO12082119/archive/2011/03/19/6261344.aspx

connect by:

[1]http://www.dba-oracle.com/t_connect_by.htm