表:test和表zq关联查询
同时按照khbm分组和jd排序
取前4条
select * from(
select t.*, row_number() over(partition by t.khbm order by t.jd desc) as rn
from (
select k.khbm, k.khqc, z.mc
from test k, zq z
where k.khbm = z.khbm
and k.lb = ‘类别’
) t
)
where rn < 5
表:test和表zq关联查询
同时按照khbm分组和jd排序
取前4条
select * from(
select t.*, row_number() over(partition by t.khbm order by t.jd desc) as rn
from (
select k.khbm, k.khqc, z.mc
from test k, zq z
where k.khbm = z.khbm
and k.lb = ‘类别’
) t
)
where rn < 5