oracle将多条数据合并成一条
来源:互联网 发布:硅谷软件学校 编辑:程序博客网 时间:2024/05/22 15:05
select tbr_id ,wm_concat(t.zz_name) as zzName from Gp_Gcjs_Tbr_Zz t group by tbr_id
下面做的一个例子,东西有点多。
select rownum as xh, ts.*
from (select t1.id,
t2.id as licenseId,
t3.org_pers_id as persId,
t1.local_code as loaclCode,
t1.local_name as localName,
t1.agc_cn_name as agcCnName,
t1.bi_reg_addr as biRegAddr,
t1.local_name as yydz,
t3.pers_name as faren,
t3.link_phone as frPhone,
t3.mobile as frTelePhone,
t1.contact_people as contactPeople,
t1.contact_phone as contactPhone,
t1.phone_num as contactTelePhone,
t2.rank as rank,
decode(t2.rank, 1, '甲级', '0', '乙级', '') as rankName,
t2.license_time_star as rantStart,
to_char(t2.license_time_star, 'yyyy-MM-dd') as rankStartStr,
t2.license_time_end as rankEnd,
to_char(t2.license_time_end, 'yyyy-MM-dd') as rankEndStr,
t1.reg_method as regMethod,
decode(t1.reg_method, 1, '注册申请', '0', '备案申请', '') as regMethodName,
t2.valid_record_star as validStart,
t2.valid_record_end as validEnd,
to_char(t2.valid_record_star, 'yyyy-MM-dd') as validStartStr,
to_char(t2.valid_record_end, 'yyyy-MM-dd') as validEndStr,
tt.valid as valid,
tt.validName as validName,
'' as khqk,
'' as fgsName,
'' as gfsFzr,
tn.shsj1 as shsj1,
tn.shsj2 as shsj2,
t1.notes as notes
from (select id,
agency_id as agencyId,
decode(sign(sign(valid_record_end - sysdate) +
sign(sysdate - valid_record_star)),
'1',
'1',
'0') as valid,
decode(sign(sign(valid_record_end - sysdate) +
sign(sysdate - valid_record_star)),
'1',
'有效',
'无效') as validName
from gp_agency_license) tt,
gp_agency t1
left join gp_agency_license t2 on t1.id = t2.agency_id
left join sys_org_pers t3 on t1.agc_orgcode = t3.jgdm
and t3.pers_type = '3'
left join (select sup_id,
substr(dateStr, 0, instr(dateStr, ',', 1, 1) - 1) as shsj1,
substr(dateStr,
instr(dateStr, ',', 1, 1) + 1,
instr(dateStr, ',', 1, 2) -
instr(dateStr, ',', 1, 1) - 1) as shsj2
from (select sup_id,
wm_concat(to_char(md_time, 'yyyy-MM-dd')) as dateStr
from (select sup_id, md_time
from gp_xy_modify t
where t.flag = '2'
order by t.md_time desc)
group by sup_id)) tn on tn.sup_id = t1.id
where 1 = 1
and t1.flag = '4'
and t1.id = tt.agencyId) ts
- oracle将多条数据合并成一条
- oracle 关键字 wm_concat 将多条数据合并成一条
- oracle 将不同数据合并成一条行数据
- oracle sql多条数据合并成一条
- linq左外联多表多条件将多条数据合并成一条
- oracle sql多条数据合并成一条,数据量大,用逗号隔开
- oracle合并多条数据为一条 wmsys.wm_concat
- MySQL将多条数据的单个字段合并成一条数据group_concat函数
- SQL合并多条数据为一条
- oracle中把查到的数据拼接成一条数据
- 关于oracle中将一张表中的多条数据的某列查询出来合并为一条数据显示
- oracle 只获取一条数据
- sqlserver中 多条数据合并成一条数据 (stuff 与 for xml path 连用)
- oracle 将多列数据合并成一列显示
- oracle表数据合并
- sqlserver 将一个字段下的多行语句合并成一条数据
- 一对多查询 只显示一条数据 数据合并
- sqlserver中将几条数据合并为一条数据
- 在如今新课改进行下,如何建立新型的师生关系
- note : current IRQL value on driver
- UIApplication
- Android Json解析详解
- OpenCV中寻找轮廓函数cvFindContours的使用说明以及序列cvSeq的用法说明
- oracle将多条数据合并成一条
- 自动化测试中角色是怎样分类的?
- Android系统启动过程
- C# 多线程task
- Oracle数据库临时表空间问题
- windows7安装Fedora双系统
- 工具解BOOT.IMG
- dede 维护关键词替换次数和频率的修改方法
- 流水灯实验