SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query Output as Merge Date Ranges

Zeeshan ShaikhJun 8 2015 — edited Jun 8 2015

Dear All,

I have a table with Data shown below:-

1-Jun-2015 to 10-Jun-2015

3-Jun-2015 to 5-Jun-2015

8-Jun-2015 to 10-Jun-2015

8-Jun-2015 to 15-Jun-2015

17-Jun-2015 to 25-Jun-2015

20-Jun-2015 to 26-Jun-2015

28-Jun-2015 to 29-Jun-2015

I want to write a query with output shown below:-

1-Jun-2015 to 15-Jun-2015

17-Jun-2015 to 26-Jun-2015

28-Jun-2015 to 29-Jun-2015

Looking forward for Help on how to write such query

Thanks

Zeeshan Sheikh

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 6 2015

Added on Jun 8 2015

11 comments

10,022 views