例如:我要根据id分组查询每组时间最新的一条数据
Oracle:
(select * from
(select id,time,row_number() over (partition by id order by time desc) rn
from XSSJ
) b1
where rn<=1
) b;
数据库分组之后查询每组最大的一条信息
最新推荐文章于 2023-12-21 15:03:10 发布
例如:我要根据id分组查询每组时间最新的一条数据
Oracle:
(select * from
(select id,time,row_number() over (partition by id order by time desc) rn
from XSSJ
) b1
where rn<=1
) b;