问题描述:
oracle 表a,有3列,id,start(date),end(date)
有两条数据:
1 2011-04-10 2011-04-11
2 2011-04-12 2011-04-13
我想显示:
1 2011-04-10
1 2011-04-11
2 2011-04-12
2 2011-04-13
开始时间和结束时间是间隔的
1 2011-04-10 2011-04-12
2 2011-04-13 2011-04-15
显示:
1 2011-04-10
1 2011-04-11
1 2011-04-12
2 2011-04-14
2 2011-04-13
2 2011-04-15
有两条数据:
1 2011-04-10 2011-04-11
2 2011-04-12 2011-04-13
我想显示:
1 2011-04-10
1 2011-04-11
2 2011-04-12
2 2011-04-13
开始时间和结束时间是间隔的
1 2011-04-10 2011-04-12
2 2011-04-13 2011-04-15
显示:
1 2011-04-10
1 2011-04-11
1 2011-04-12
2 2011-04-14
2 2011-04-13
2 2011-04-15
问题解答:
我来补答展开全文阅读