SELECT A.告警码,A.告警对象名称,A.告警对象类型,A.告警对象ID,COUNT(*) count,B.week_count
FROM alldata AS A
left join
(
SELECT 告警码,告警对象名称,告警对象类型,告警对象ID,Count(*) as week_count
FROM alldata
WHERE (发生时间>'2019-12-01 00:00:00' and 发生时间<'2019-12-02 00:00:00')
GROUP BY 告警码,告警对象名称,告警对象类型,告警对象ID
) B
ON A.`告警码`=B.`告警码` AND A.`告警对象名称`=B.`告警对象名称` AND
A.`告警对象类型`=B.`告警对象类型` AND A.`告警对象ID` AND B.`告警对象ID`
WHERE (A.发生时间>'2019-12-01 00:00:00' and A.发生时间<'2019-12-02 00:00:00')
GROUP BY A.告警码,A.告警对象名称,A.告警对象类型,A.告警对象ID
mysql sql两次查询结果连接并一行展示
最新推荐文章于 2022-07-08 17:48:36 发布