mybatis登录的sql语句怎么使用
发布网友
发布时间:2022-04-22 08:03
我来回答
共1个回答
热心网友
时间:2022-04-07 22:30
你不是已经写出来了吗?小小的修改如下:
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