SELECT deptno, LIST_AGG(ename) AS EMP_STRING FROM emp GROUP BY deptno;

how to get enames with comma seperated values by deptwise
on emp table?

Question Posted / gj

Answer Posted / gj

SELECT deptno, LIST_AGG(ename) AS EMP_STRING
FROM emp
GROUP BY deptno;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what are the drivers in mysql? : Sql dba

1031

what is 'mysqlshow'? : Sql dba

1040

How many indexes can be created on a table in sql?

1066

how to analyze tables with 'mysqlcheck'? : Sql dba

1018

Is sql pronounced sequel or sql?

1282

what is single byte over head in oracle..?

2413

Which is faster subquery or join?

1231

Is mariadb nosql?

1049

What is scalar and vector?

1015

Is sql a oracle?

986

Which tcp/ip port does sql server run?

1020

What is trigger point?

1002

What does count (*) mean in sql?

1598

what is the syntax for using sql_variant_property? : Transact sql

1056

What is rollback?

1121