SQL 栏位排序

[冰痕001]

如下图，根据栏位进行排序：
每一行对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都可以

[冰痕001]

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