尝试使用sql在单行中获取结果? [英] Trying to get the result in single row using sql?

问题描述

我正在尝试显示所有员工ID's

I'm trying to display all the employee id's

我需要这样的结果

emp_id

10,11,12,13,14,15..,...

尝试过

SELECT LISTAGG(emp_id, ',') WITHIN GROUP (ORDER BY emp_id) AS ID FROM employees GROUP BY emp_id;

我遇到错误

ORA-00923: FROM keyword not found where expected

问题出在哪里?

推荐答案

使用LISTAGG函数.有关更多详细信息，请参考此处.像这样尝试

Use LISTAGG function. Refer here for more in detail. Try like this,

SELECT listagg(emp_id,',') WITHIN GROUP(ORDER BY emp_id) t 
FROM   employees;

这篇关于尝试使用sql在单行中获取结果?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！