SELECT count(1) FILTER (WHERE flag_xiaofang = 1) AS xiaofang,
count(1) FILTER (WHERE flag_weihua = 1) AS weihua,
count(1) FILTER (WHERE flag_huanbao = 1) AS huanbao,
count(1) FILTER (WHERE flag_sanchangsuo = 1) AS sanchangsuo
FROM tbl_enterprise
SQL FILTER 关键字的应用
最新推荐文章于 2024-05-02 01:04:40 发布