hi vijayan

this is my query

SELECT DISTINCT

A.EMP_STAFFID "Employee Code",

--O.TRANS_GOAL_COMP_TYPE,

NT.TRANS_GOAL_COMP_NAME C,

NT1.TRANS_GOAL_COMP_NAME G,

--CASE WHEN O.TRANS_GOAL_COMP_TYPE='C' THEN o.TRANS_GOAL_COMP_NAME else '' END C,

--CASE WHEN O.TRANS_GOAL_COMP_TYPE='G' THEN o.TRANS_GOAL_COMP_NAME else ''END G,

--O.TRANS_GOAL_COMP_WEIGHTAGE,

A.EMP_FIRSTNAME +...