欄位1 欄位2
1 2
1 3
2 1
2 2
變為----》
欄位1 欄位2
1 2
3
2 1
2
uj5u.com熱心網友回復：
with a as(
select 1 col1, 2 col2 from dual union all
select 1, 3 from dual union all
select 1, 4 from dual union all
select 2, 1 from dual union all
select 2, 2 from dual)
select nullif(col1,lag(col1) over(partition by col1 order by rownum)) col1,col2
from a;
uj5u.com熱心網友回復：
uj5u.com熱心網友回復：
換個方式with a as(
select 1 col1, 2 col2 from dual union all
select 1, 3 from dual union all
select 1, 4 from dual union all
select 2, 1 from dual union all
select 2, 2 from dual)
select decode(row_number() over(partition by col1 order by col2),1,col1) col1,col2
from a;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/117732.html
標籤：開發