您可以使用分析函数：

select *
from (
    select 
        t.*, 
        row_number() over(partition by id order by repeat_cycle desc) rn
    from mytable t
) t
where rn = 1

或者，如果表中只有三列，则 keep 语法可能合适：

select
    id,
    max(date) keep(dense_rank first order by repeat_cycle desc) date,
    max(repeat_cycle) repeat_cycle
from mytable

你可以用 row_number() ,

select id, date, repeat_cycle from
(select id, date, repeat_cycle, row_number() over(partition by id order by repeat_cycle desc) as rnk from table_name)
qry where rnk = 1;

你可以用 max() 以及 group by .

select
    t.id,
    max(t.repeat_cycle)
from
    table t
group by
    t.id

其中table是您的真实表名。

我建议您不要使用“date”之类的关键字或“table”之类的表来调用列

select t1.id, t1.date_c, t1.repeat_cycle      
from table_t t1
where (t1.id, t1.repeat_cycle) in (select t2.id, max(t2.repeat_cycle)
                                   from table_t t2
                                   group by t2.id);

这是一个演示