SELECT
dd.id as ids,
dt.platenumber as platenumber,
dd.deviceId as deviceId,
dd.exceptionTime as exceptionTime,
sd1.`Name` as exceptionSituation,
sd2.`Name`as exceptionClassify,
sd3.`Name` as status
FROM
dc_device_monitor dd
LEFT JOIN dc_truck_truck dt ON dd.deviceId = dt.deviceId
LEFT JOIN sys_dictionary sd ON sd.id = dd.`status`
LEFT JOIN sys_dictionary sd1 ON dd.exceptionSituation = sd1.id
LEFT JOIN sys_dictionary sd2 ON dd.exceptionClassify = sd2.id
LEFT JOIN sys_dictionary sd3 ON dd.`status` = sd3.id
where 1=1
ORDER BY dd.deviceId,dd.exceptionTime DESC
orderby必须写在where后面
MYSQL分组查询可以按照日期倒叙
最新推荐文章于 2023-07-04 16:01:18 发布
此SQL查询从dc_device_monitord表中获取设备异常信息,并通过LEFT JOIN连接其他字典表,获取异常情况、分类及状态的详细名称。查询结果按设备ID和异常时间降序排列,用于设备监控系统的数据分析。
摘要由CSDN通过智能技术生成