sql date operation split
can greatfully let me know sql separate date ranges overlap?
data (sample information date operation presumably columns):
col1 fromdate todate
1. 1 1/1/2008 31/12/2010
2. 1 1/1/2009 31/12/2012
3. 1 1/1/2009 31/12/2014
output:
col1 date todate
1. 1 1/1/2008 31/12/2008 (from quarrel 1 above)
2. 1 1/1/2009 31/12/2010 (from rows 1,2 3 above)
3. 1 1/1/2011 31/12/2012 (from rows 2 3 above)
4. 1 1/1/2013 31/12/2014 (from quarrel 3 above)
Comments
Post a Comment