如下圖，根據欄位進行排序：
每一行對a_time，b_time，c_time，d_time，e_time 進行排序，排序結果放在Reltestseq欄位。
例如：SAM 如果a_time<=b_time<=c_time<=d_time<=e_time 則在Reltestseq 欄位放a,b,c,d,e或者1，2，3，4，5都可以
uj5u.com熱心網友回復：
with t001 as (select id,'A' AS ORDERS,a_testtime as test_time FROM testSortseq
UNION ALL
select id,'B' AS ORDERS,B_testtime as test_time FROM testSortseq
UNION ALL
select id,'C' AS ORDERS,C_testtime as test_time FROM testSortseq
UNION ALL
select id,'D' AS ORDERS,D_testtime as test_time FROM testSortseq
UNION ALL
select id,'E' AS ORDERS,E_testtime as test_time FROM testSortseq
)
select id,listagg(orders,',')within group(order by test_time) seqs from t001 group by id order by id
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/14688.html
標籤：高級技術