Question

有多个子查询的sql语句中在mybatis怎么写

<select id="selectByTCR" resultType="com.securityeva.model.CommonType" parameterType="Map">
SELECT we.safeTypeId,COUNT(safeTypeId) as safeTypeId,com.name from se_weak_analysis we,se_common_type com where
riskLevel=#{riskLevel} and we.safeTypeId=com.id and infosysId=(select id from se_info_sys
where id in(select infosysId from se_report where uploadTime between
#{beginTime} and #{endTime} GROUP BY infosysId) and netTypeId=#{netTypeId}
GROUP BY netTypeId) GROUP BY safeTypeId;
</.select>

Answer 1

你不是已经写出来了吗？小小的修改如下：
<select id="selectByTCR" resultType="com.securityeva.model.CommonType" parameterType="Map">
SELECT we.safeTypeId,COUNT(safeTypeId) as safeTypeId,com.name
from se_weak_analysis we,se_common_type com
where riskLevel=#{riskLevel}
and we.safeTypeId=com.id
and infosysId in ( select id
from se_info_sys
where id in(
select infosysId
from se_report
where uploadTime between#{beginTime}
and #{endTime}
GROUP BY infosysId )
and netTypeId=#{netTypeId}
GROUP BY netTypeId)
GROUP BY safeTypeId
</select>