DELETE
FROM
t_device_value_hour
WHERE
id NOT IN (
SELECT
*
FROM
(
SELECT
min(id) id
FROM
t_device_value_hour
GROUP BY
device_id,
device_value,
use_value,
fee,
group_id,
create_time,
node_type_id,
real_value,
device_channel_id,
channel,
node_type_name
ORDER BY id
) as a
)