mysql 分组查询以及显示各个分组所有的温度和时间要用GROUP_CONCAT

select GROUP_CONCAT(a.TEMPERATURE)TEMPERATURE,GROUP_CONCAT(DATE_FORMAT(a.OCCUR_TIME,'%H:%i'))OCCUR_TIME,a.THERMO_TYPE,a.THERMO_ID FROM select GROUP_CONCAT(a.TEMPERATURE)TEMPERATURE,G