oracle 表a,有3列,id,start(date),end(date)有两条数据:1 2011-04-10 2011-04-112 2011-04-12 2011-04-13我想显示:1 2011-04-101 2011-04-112 2011-04-12 2 2011-04-13开始时间和结束时间是间隔的1 2011-04-10 2011-04-122 2011-0
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/27 13:25:33
![oracle 表a,有3列,id,start(date),end(date)有两条数据:1 2011-04-10 2011-04-112 2011-04-12 2011-04-13我想显示:1 2011-04-101 2011-04-112 2011-04-12 2 2011-04-13开始时间和结束时间是间隔的1 2011-04-10 2011-04-122 2011-0](/uploads/image/z/11845486-46-6.jpg?t=oracle+%E8%A1%A8a%2C%E6%9C%893%E5%88%97%2Cid%2Cstart%EF%BC%88date%EF%BC%89%2Cend%EF%BC%88date%EF%BC%89%E6%9C%89%E4%B8%A4%E6%9D%A1%E6%95%B0%E6%8D%AE%EF%BC%9A1+2011-04-10+2011-04-112+2011-04-12+2011-04-13%E6%88%91%E6%83%B3%E6%98%BE%E7%A4%BA%EF%BC%9A1+2011-04-101+2011-04-112+2011-04-12+2+2011-04-13%E5%BC%80%E5%A7%8B%E6%97%B6%E9%97%B4%E5%92%8C%E7%BB%93%E6%9D%9F%E6%97%B6%E9%97%B4%E6%98%AF%E9%97%B4%E9%9A%94%E7%9A%841+2011-04-10+2011-04-122+2011-0)
oracle 表a,有3列,id,start(date),end(date)有两条数据:1 2011-04-10 2011-04-112 2011-04-12 2011-04-13我想显示:1 2011-04-101 2011-04-112 2011-04-12 2 2011-04-13开始时间和结束时间是间隔的1 2011-04-10 2011-04-122 2011-0
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
oracle 表a,有3列,id,start(date),end(date)有两条数据:1 2011-04-10 2011-04-112 2011-04-12 2011-04-13我想显示:1 2011-04-101 2011-04-112 2011-04-12 2 2011-04-13开始时间和结束时间是间隔的1 2011-04-10 2011-04-122 2011-0
select * from
(select a.id,a.start as tdate
union all
select a.id,a.end as tdate) t
order by t.id,t.tdate