表:
一:oracle行列转换,逗号分隔,数据引号设置
select wm_concat(name1) name2 from (
(select ''''||max(t2.version_code)||'''' as name1 from cns_templet t2 GROUP BY oper_id)
)
结果:
二:查询字段值作为查询条件
select * from cns_templet t where t.version_code in (
select max(t2.version_code) as name1 from cns_templet t2 GROUP BY oper_id
)
结果:
三:| | 的使用
SELECT '字段a'||'+'||'字段b' A FROM DUAL