hiiie,
no empno name
11 91 Man
11 92 DR
11 93 PAT
13 94 MANU
13 95 DRA
13 96 PAT
suppose i have a input like the above and i want a op like
no emp1 emp 2 emp3
11 91 92 93
13 94 95 96
using pivot i tried but not getting
thnx