mysql - sql的問題 ：查詢的結果作再篩選

問題描述

一句sql可以寫出來嘛？

SELECT pap., pm.,COUNT(pap.user_id) tzCount,SUM(pap.invest_amount) tzAmout FROM tb_pro_attended_apply pap LEFT JOIN tb_pro_main pm ON pap.pro_id=pm.id WHERE 1=1GROUP BY pap.pro_id ORDER BY pap.apply_time

現在我要篩選tzAmout >10的為什么不行

這是子查詢的結果

問題解答

SELECT pap., pm.,COUNT(pap.user_id) tzCount,SUM(pap.invest_amount) tzAmout

FROM tb_pro_attended_apply pap LEFT JOIN tb_pro_main pm ON pap.pro_id=pm.id WHERE 1=1GROUP BY pap.pro_id HAVING 1=1 <if test='minAmout != null and minAmout !=’’ '> <![CDATA[and tzAmout >= ${minAmout} ]]> </if> <if test='maxAmout != null and maxAmout !=’’ '><![CDATA[and tzAmout <= ${maxAmout} ]]> </if> <if test='minC != null and minC !=’’ '> <![CDATA[and tzCount >= ${minC} ]]> </if> <if test='maxC != null and maxC !=’’ '><![CDATA[and tzCount <= ${maxC} ]]> </if> ORDER BY pap.apply_time <if test='startIndex != null '> limit #{startIndex}<![CDATA[,]]>#{pageSize} </if>