原生SQL
AlexKate
这个作者很懒,什么都没留下…
展开
-
原生SQL
SELECT config.dwid, config.dwname, config.displaycode, config.displayname, gather.origclassFROM `eqm_equipdisplayconfig` configLEFT JOIN eqm_equipgather_item gather ON gather.dwid = config.dwi...原创 2018-03-30 17:53:45 · 1067 阅读 · 0 评论 -
原生SQL分组查询
SELECT t.time, COUNT(t.time) countFROM ( SELECT substring(alarm.occurtime, 1, 10) time, alarm.equiprecorddwid dwid, alarm.alarmmode, alarm.equiprecorditemname FROM `eqm_alarm_ev...原创 2018-04-03 12:41:08 · 542 阅读 · 0 评论 -
原生SQL组建查询
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...原创 2018-03-29 15:10:50 · 269 阅读 · 0 评论