有重复行,查询时只保留最新一行的sql时间:2023-03-09 08:36:25 一、表结构如下:表名test 二、sql select temp.* from (select test.*, row_number() over(partition by obd_code order by odd desc) rm from test) temp where temp.rm = 1;