Oracle 多行分多列
Select * FROM ( Select sprid,RWID,spsj,spyj,sprmc from T_PROJ_DBRW_SPYJ Where sprid In('A','B','C','D') --And RWID in(56295,56186) ) pivot( Max(spsj) spsj,Max(spyj) spyj,Max(sprmc) sprmc For sprid In('A' A,'B' B,'C' C,'D' D) )
https://www.bilibili.com/read/cv25571204/
select a.userid,a.username, level lev, regexp_count(a.REMARK,'[^|]+') as regcou, regexp_substr(a.REMARK,'[^|]+',1,level) as deptid from sys_user_EMPLOYEE a Where a.REMARK Is Not Null connect by prior a.userid = a.userid and prior dbms_random.value is not null and level <= regexp_count(a.REMARK,'[^|]+')
列转行,使用 | 分隔
select ztid,to_char(wm_concat(hf)) name From (
Select ztid,to_char(clrxm)||' 于 '||to_char(clsj,'yyyy-MM-dd HH24:mi')||' 回复: '|| nr ||'\n' hf
FROM V_DDSX_LYFK
Where ztid>0 And yxzt=1
)
Group By ztid
SELECT T.tid,
LISTAGG(hf , CHR(10))
WITHIN GROUP(ORDER BY T.tid)
From
(
Select ztid tid,to_char(clrxm)||' 于 '||to_char(clsj,'yyyy-MM-dd HH24:mi')||' 回复: '|| nr || CHR(13) hf
FROM t_DDSX_LYFK
Where ztid>0 And yxzt=1
)
T
GROUP BY T.tid
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步