1.使用条件查询 查询部门为20的员工列表
-- 查询部门为20的员工列表
SELECT
T."DEPTNO",
T."ENAME"
FROM
"EMP" T
WHERE
T."DEPTNO" = '20'
效果:
2.使用 listagg() 将多行合并成一行(比较常用)
SELECT
T."DEPTNO",
string_agg ( T."ENAME", ',' ) AS NAMES
FROM
"EMP" T
WHERE
T."DEPTNO" = '20'
GROUP BY
T."DEPTNO";
效果:
mysql相同效果的实现 https://blog.csdn.net/sinat_36257389/article/details/95052001
Oracle相同功能的实现 https://blog.csdn.net/sinat_36257389/article/details/81004843