有重复行，查询时只保留最新一行的sql
标签：查询 rom col ges partition art esc div style
有重复行，查询时只保留最新一行的sql
temp.*
from (select test.*,
row_number() over(partition by obd_code order by odd desc) rm
from test) temp
where temp.rm = 1;