---分组求最大日期
---1
select t1.*,t1.rowid from get_oracle_cpu t1,
(select ip_address,max(insert_time) insert_time from get_oracle_cpu group by ip_address) t2 where t1.ip_address=t2.ip_address
and t1.insert_time=t2.insert_time
---2
select t1.*,t1.rowid from get_oracle_cpu t1 where insert_time=(select max(insert_time) as insert_time from get_oracle_cpu t2 where t1.ip_address=t2.ip_address)
---1
select t1.*,t1.rowid from get_oracle_cpu t1,
(select ip_address,max(insert_time) insert_time from get_oracle_cpu group by ip_address) t2 where t1.ip_address=t2.ip_address
and t1.insert_time=t2.insert_time
---2
select t1.*,t1.rowid from get_oracle_cpu t1 where insert_time=(select max(insert_time) as insert_time from get_oracle_cpu t2 where t1.ip_address=t2.ip_address)