AlexKate的博客

SELECT config.dwid, config.dwname, config.displaycode, config.displayname, gather.origclass FROM `eqm_equipdisplayconfig` config LEFT JOIN eqm_equipgather_item gather ON gather.dwid = config.dwi...

SELECT t.time, COUNT(t.time) count FROM ( SELECT substring(alarm.occurtime, 1, 10) time, alarm.equiprecorddwid dwid, alarm.alarmmode, alarm.equiprecorditemname FROM `eqm_alarm_ev...

String sql = "SELECT gather.dwid,gather.dwname,recorditem.unit,record.id equiprecordid,record.equipname FROM eqm_equipgather_item gather LEFT JOIN eqm_equiprecord_item recorditem ON gather.equiprecord...