menglongbor的专栏

pg的with查询结合COALESCE将未查询到记录的内容默认置零with t as ( select ('CNY') union select ('USD')union select ('EUR') union select ('JPY') union select ('HKD'))select t."?column?" as currency,case when amount is null then 0 else amount end as amountfrom t left jo...