Singaram writes "TABLE 1-------EMP_SKILLS----------EMPNO SKILL_ID----------------------- 100 SKILL1,SKILL3,SKILL5,SKILL6 200 SKILL2 300 SKILL4,SKILL3,SKILL1 400 SKILL5TABLE 2-------SKILLS------SKILL_ID DESC----------------------SKILL1 VBSKILL2 ORACLESKILL3 SQL SERVERSKILL4 JAVASKILL5 ASPSKILL6 XMLI need values as follows------------------------EMPNO SKILLS---------------------------100 VB SQL SERVER ASP XML200 ORACLE300 JAVA SQL SERVER VB400 ASP
Expecting your reply at the earliest.with regards,S.Murugappan."
query needed 
Posted - 2002-03-19 : 11:17:56
Seriously, take apart the CSV with a few replaces, and a tally table, keeping the tally value so you retain the ordering of SKILL_ID. Join it to SKILLS, and in the output, suppress the EMPNO if that row does not have the min tally value for that employee.