本文介绍了一个具体的SQL查询案例，展示了如何使用LISTAGG函数结合GROUP BY进行数据聚合操作，特别关注于从两个关联表中提取特定站点代码下的计量表类型。
select sitecode,listagg(ammetertype,',') within GROUP (order by ammetertype) ammetertype from
(select distinct t1.sitecode,t2.ammetertype from tb_tres_sititenement t1 left join tb_tres_sitemachineroom t2 on t1.sitecode=t2.sitecode)
WHERE SITECODE ='210602908001900005'
(select distinct t1.sitecode,t2.ammetertype from tb_tres_sititenement t1 left join tb_tres_sitemachineroom t2 on t1.sitecode=t2.sitecode)
WHERE SITECODE ='210602908001900005'
group by sitecode
扫一扫
647
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
