注解case的应用

最新推荐文章于 2024-07-24 17:27:32 发布

weixin_47467938

最新推荐文章于 2024-07-24 17:27:32 发布

阅读量74

点赞数

文章标签： java

本文链接：https://blog.csdn.net/weixin_47467938/article/details/127209403

版权

SELECT count(1) partyMemberCount," +
            "sum(case when is_volunteer = 1 then 1 else 0 end) partyVolunteerCount," +
            "sum(case when party_post = '1' then 1 else 0 end) secretaryCount," +
            "sum(case when party_post = '2' then 1 else 0 end) committeeCount " +
            "FROM tbl_party_member pm " +
            "INNER JOIN tbl_party p ON p.id = pm.party_id " +
            "WHERE oid in (SELECT oid FROM tbl_org WHERE oid_path like '%/' || #{oid} || '/%')