select t.tid,t.*,z.*,f.* from 表1 t,表2 z,
(select * from (select rank() over(partition by bd_id order by p_id desc) r,a.* from 表3 a) where r=1) f
where t.tid=z.zid and 1=1 and t.tid=f.fid
oracle 多表关联查询出多个字段并根据某一字段进行去重展示
最新推荐文章于 2024-07-16 11:54:08 发布