比如表A:
A a
A b
A c
B a
B b
對兩個同時分組編號,得到如下:
A a 1 1
A b 1 2
A c 1 3
B a 2 1
B b 2 3
請問各位, 在不進行 select * from ( .. ) 嵌套的時候, 這個sql該怎么寫?
uj5u.com熱心網友回復：
dense_rank() over(order by a1),rank() over(partition by a1 order by a2)
uj5u.com熱心網友回復：
把規劃描述清楚。uj5u.com熱心網友回復：
試試下面的方案：
create table tmp as
select 'A' as c1,'a' as c2 from dual union all
select 'A' as c1,'b' as c2 from dual union all
select 'A' as c1,'c' as c2 from dual union all
select 'B' as c1,'a' as c2 from dual union all
select 'B' as c1,'b' as c2 from dual
select c1,c2,dense_rank() over(order by c1) as dr, rank() over(partition by c1 order by c2) as rk from tmp;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/62141.html
標籤：開發
上一篇：oracle導庫impdp報錯