Home » SQL & PL/SQL » SQL & PL/SQL » Please help
|Please help [message #388935]
||Thu, 26 February 2009 12:46
Registered: January 2007
I have a requirement as below. My table contains data in the below format.
EMPNO ENAME JOB PLAN PLANROUND PLAN_Description
100 ABC HR A 1 plan1
100 ABC HR A 1 plan2
100 ABC HR c 2 plan3
100 ABC HR d 3 plan4
200 DEF MGR x 4 plan7
200 DEF MGR x 5 plan8
200 DEF MGR x 5 plan9
200 DEF MGR z 6 plan10
300 MNO CLK M 7 plan11
so for each employee how many different combinations are coming from plan,planround, plan_description columns,
I have to show in a single row for each employee.
for example Employee 100 has following values for
plan,planround, plan_descriptio columns.
A 1 plan1
A 1 plan2
c 2 plan3
d 3 plan4
so I have to show like A,1,plan1,plan2,c,2,plan3,d,3,plan4
Finally I have to show total report as below.
Could you please help me how to do this?
Thanks in advance
Current Time: Sun Oct 23 01:14:43 CDT 2016
Total time taken to generate the page: 0.23566 seconds