SELECT MAX(temperature),MIN(temperature), HOUR(create_time) time from par_rdm
where date(create_time) = '2021-10-25' AND deviceCode='RDM_FS_01' GROUP BY time;
SELECT MAX(temperature),MIN(temperature), HOUR(create_time) time from par_rdm
where create_time like '2021-10-25%' AND deviceCode='RDM_FS_01' GROUP BY time;
上面这两SQL 语句,where 的写法不一样,效率上哪个更高?为什么?