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
10383 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

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3988

What does the hierarchical profiler does?

1048

What is trigger in sql? Explain

976

What is a function in oracle pl sql?

1014

What is synonyms?

1039

What are conditional predicates?

1033

What is sql profiler in oracle?

1070

What are the subsets of sql?

1103

How can triggers be used for the table auditing?

1049

how can we know the count/number of elements of an array? : Sql dba

1044

How many developers work on postgresql?

955

what is the different between now() and current_date()? : Sql dba

994

How many postgresql users are there, worldwide?

1045

What is the difference between an inner join and an outer join?

1001

How does postgresql compare to oracle/db2/ms sql server/informix?

1017