agg
-
pgsql或取最新的一条数据
SELECT company.id,company.zz,snap.xydm,snap.”companyName”, p.xm fr from ( SE…
-
postgresql 合并函数 string_agg
SELECT a.id,a.name as “companyName”,a.xydm,a.fddbr,string_agg(case when d.zzlx…
SELECT company.id,company.zz,snap.xydm,snap.”companyName”, p.xm fr from ( SE…
SELECT a.id,a.name as “companyName”,a.xydm,a.fddbr,string_agg(case when d.zzlx…