select nvl(b.weight, 0),a.time from
(select to_char(to_date(开始时间, 'yyyy-mm-dd') + rownum - 1, 'yyyy-mm-dd') as time
from dual
connect by rownum <= trunc(to_date(结束时间, 'yyyy-mm-dd') - to_date(开始时间, 'yyyy-mm-dd')) + 1) a
left join (
自己的业务
) b on a.time = b.time order by a.time desc
如对本文有疑问, 点击进行留言回复!!
荐 嵌入式linux开发环境搭建(Docker版,基于iTop 4412开发板)
SpringBoot项目部署到服务器之 Liunx环境安装jdk详细步骤
网友评论