select cust,wmsys.wm_concat(acc) from tbl group by cust;

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.

Question Posted / kpk

7 Answers
10665 Views
MTS, I also Faced
E-Mail Answers

Answer Posted / kpk

select cust,wmsys.wm_concat(acc) from tbl group by cust;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Are dml statements autocommit?

1096

What is sql lookup?

974

What is dcl in sql?

1024

What is an escape character in sql?

1075

What is the usage of when clause in trigger?

1091

Can you rollback after commit?

1054

What is the difference between clustered and non-clustered indexes?

1132

Are stored procedures faster than queries?

991

What is parallel hint?

1416

Sql technical questions

1337

How does rowid help in running a query faster?

1476

Explain the difference between 'between' & 'and' operators in sql

1046

Write a query to display the current date in sql?

1078

Can we join 3 tables in sql?

1109

Can a key be both primary and foreign?

1055