在PrestoDB中，我倾向于使用
row_number()：
select id, name, datefrom (select t.*, row_number() over (partition by name order by date desc) as seqnum from table_name t ) twhere seqnum = 1;
在PrestoDB中，我倾向于使用
row_number()：
select id, name, datefrom (select t.*, row_number() over (partition by name order by date desc) as seqnum from table_name t ) twhere seqnum = 1;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
