使用60 Reg/Line将垂直数据转换为水平数据

Question

从该表中，

Name  surname  Phone
Name1 Sur1     Myphone1
Name2 Sur2     Myphone2
Name3 Sur3     Myphone3
Name4 Sur4     Myphone4
...
Name100 Sur100  Myphone100

我想以这种方式进行选择，水平排列60行寄存器。

Name1Sur1Myphone1, ... Name60Sur60Myphone60
Name61Sur61Myphone61, ... Name100Sur100Myphone100

有人知道我该怎么做吗？谢谢-

Answer 1

试试这个：

/*
WITH 
MYTAB (RN_, Name, surname, Phone) AS
(
VALUES (1, 'Name1', 'Sur1', 'Myphone1')
UNION ALL
SELECT 
RN_ + 1
, 'Name'    || TRIM (CHAR (RN_+1)) 
, 'Sur'     || TRIM (CHAR (RN_+1))
, 'Myphone' || TRIM (CHAR (RN_+1))
FROM MYTAB
WHERE RN_ < 100
)
*/
SELECT LISTAGG (Name || surname || Phone, ',')  
FROM
(
SELECT ROW_NUMBER () OVER () AS RN_, Name, surname, Phone
FROM MYTAB
) T
GROUP BY (RN_ - 1) / 60
ORDER BY (RN_ - 1) / 60