SELECT * FROM (
SELECT id,ip, row_number() over (partition by ip order by tm desc),cpu_use,disk_use,net_in FROM hw_info
) AS de_dump WHERE row_number = 1
ip地址是分组依据,tm字段是排序依据,别的字段随便写
SELECT * FROM (
SELECT id,ip, row_number() over (partition by ip order by tm desc),cpu_use,disk_use,net_in FROM hw_info
) AS de_dump WHERE row_number = 1
ip地址是分组依据,tm字段是排序依据,别的字段随便写