可以使用以下方法將結果顯示為一行:
SELECT GROUP_CONCAT(column_name SEPARATOR ' ')
FROM table_name;
SELECT LISTAGG(column_name, ' ') WITHIN GROUP (ORDER BY column_name) "Result"
FROM table_name;
SELECT t1.column_name || ' ' || t2.column_name AS result
FROM table_name t1, table_name t2
WHERE t1.id = t2.id
AND t1.column_name <> t2.column_name;
請根據你的具體情況選擇適合的方法。