oracle 语句

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