image

Oracle 10g VS 11g(LISTAGG) SQL

Hello Friend i have a table like EMPID SKILLS SUBSKILL —— ——————– ——————– 22 oracle dba 22 oracle plsql i want to output that EMPID SKILLS SUBSKILL —— ——————– ——————– 22 oracle dba,plsql Solution: SELECT EMPID, SKILLS,LISTAGG(SUBSKILL, ‘,’) WITHIN GROUP (ORDER BY SUBSKILL) AS SUBSKILLFROM TABLENAMEGROUP BY EMPID. This solution will work for oracle 11gR2 … continue reading

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube