oracle 语句

最新推荐文章于 2024-08-14 11:03:14 发布

转载最新推荐文章于 2024-08-14 11:03:14 发布 · 183 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

原文链接：http://www.cnblogs.com/BLE77/p/5166901.html

标签

#数据库

收录于

1.查询TRENDCHART_DLT表中的30条数据，统计字段FRONT01='0'，BACK12='0'的条数

select sum(case when FRONT01='0' then 1 else 0 end) FRONT01,
sum(case when BACK12='0' then 1 else 0 end) BACK12
from
(select * from
(select * from TRENDCHART_DLT order by ISSUE desc)
where rownum < 31)

2.添加ticketdetail_temp表一条数据，从历史表中查出数据在添加

insert into ticketdetail_temp select * from ticketdetail where printticketid='1524875236'

3.常用的三函数

select
substr(sum(t.front01)/30,1,1) FRONT01,replace(replace(attop,'0','否'),'1','是') attop,to_char(to_date(t.infodatetime,'yyyymmddhh24miss'),'mm-dd hh24:mi') as recvdatetime1 from trendchart_dlt t

4.把数据组成如图展示

select issue,wm_concat(front01||','||front02||','||front03||','||front04||','||front05) issueNum
from (select * from trendchart_dlt order by issue desc) t where rownum<10
group by issue order by issue desc

转载于:https://www.cnblogs.com/BLE77/p/5166901.html