![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
冷风阿健
这个作者很懒,什么都没留下…
展开
-
oracle中同N天前每小时数据对比,数据列在同一行
select to_char(a.create_time, ‘hh24’) 小时, sum(case when to_char(a.create_time, ‘yyyymmdd’) =to_char(sysdate,‘yyyymmdd’) then data end ) 当前天每小时数据求和, sum(case when to_char(a.create_time, ‘yyyymmdd’)...原创 2020-04-23 09:54:45 · 296 阅读 · 0 评论 -
oracle利用listagg把多列合成一行并用指定分隔符分割
select listagg(serial_number, ‘’’,’’’) within group (order by serial_number) ||’’’’ from table where rownum<5;原创 2020-04-22 10:38:08 · 1361 阅读 · 0 评论 -
oralce中如何将多列合成一行,并用分隔符来分割
oralce中如何将多列合成一行,并用分隔符来分割,以下是SQL: select listagg(serial_number, ‘’’,’’’) within group (order by serial_number) ||’’’’ from table where rownum<5; ...原创 2020-04-21 09:24:28 · 648 阅读 · 0 评论