id_, coll_time_, device_code_, src_data_, sdata_, voltage_, create_time_, last_time_ SELECT b.*,d.name_ as deviceName FROM device_data_water b LEFT JOIN device_info d ON d.code_ = b.device_code_ ${ew.customSqlSegment} SELECT #{dto.time} time, max( ddw.SDATA_ ) waterLevel, IFNULL(di.NAME_, '') deviceName FROM device_data_water ddw LEFT JOIN device_info di on di.CODE_ = ddw.DEVICE_CODE_ WHERE DATE_FORMAT( ddw.COLL_TIME_, #{dto.dateType} ) = #{dto.time} GROUP BY deviceName