. have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I

. have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.
CUST ACC
a dv
b fg
b bh
c mk
c cl
c so
result:-
A B c
dv fg mk
bh cl
so

Question Posted / swastik

3 Answers
5255 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

. have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust..

Answer / phanikumar kode

select cust,listagg(acc,' ') within group(order by acc) from tbl group by cust;

Is This Answer Correct ?

2 Yes

0 No

. have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust..

Answer / barun

select decode(cust,'a',acc) as A ,decode(cust,'b',acc) as B,decode(cust,'c',acc) AS C from customer

Is This Answer Correct ?

1 Yes

0 No

. have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust..

Answer / ramaraju

select cust,listagg(acc,'|') within group(order by acc) from t2 group by cust;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer