使用简单聚合：

select  id, max(time) as time
  from table
group by id
order by id; --order if necessary

使用数据集演示：

select id, max(time) as time 
from
table
group by id

OK
10038446        201706060100
10103517        201706060100
10124464        201706060100
Time taken: 30.66 seconds, Fetched: 3 row(s)

试试这个

select ID, time
from
(
  select 
    ID, 
    time, 
    row_number() over (partition by ID order by time desc) as time_rank
  from table_name
 ) x
where time_rank = 1
group by ID, time

没有子查询（低配置单元版本），临时表是一个选项。

create table tmp_table as
select 
  ID, 
  time, 
  row_number() over (partition by ID order by time desc) as time_rank
from table_name;

select ID, time
from tmp_table
where time_rank = 1
group by ID, time;

drop table tmp_table;