可以使用以下方法将结果显示为一行:
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;
请根据你的具体情况选择适合的方法。
亿速云「云服务器」,即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘,价格低至29元/月。点击查看>>
推荐阅读:sql如何把多行显示为一行