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