本文主要是介绍取出分组之后每组前10条数据 oracle，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
--取出x || '_' || y 分组之后每组前10条数据select * from (
select x,y,sj,ddbz,
row_number() over (partition by x || '_' || y order by sj desc) rn
from test
where x is not null and y is not null
) where rn <= 10
--行转列数据
select x|| '_' || y jdwd, wm_concat(distinct DDBZ) from(
select * from (
select x,y,sj,ddbz,
row_number() over (partition by x || '_' || y order by sj desc) rn
from qb_gissj
where x is not null and y is not null
) where rn <= 10)
group by (x || '_' || y)
这篇关于取出分组之后每组前10条数据 oracle的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
