select t.* from (select a.*, row_number() over(partition by a.columns1 order by a.columns2 desc) ss from table_name a ) t where t.ss = 1;
oracle如何去重
最新推荐文章于 2024-07-25 15:39:38 发布
select t.* from (select a.*, row_number() over(partition by a.columns1 order by a.columns2 desc) ss from table_name a ) t where t.ss = 1;