select c.* from (select 表.*, row_number() over(partition by 表.标识 order by 表.排序属性 desc) rn from 表) c
where rn = 1;
Oracle 查询表里第一条或者最后一条数据
于 2024-01-24 09:20:46 首次发布
select c.* from (select 表.*, row_number() over(partition by 表.标识 order by 表.排序属性 desc) rn from 表) c
where rn = 1;