select cust, wm_conact(acc) as acc from table 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 / trainedforjob

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

Answer Posted / trainedforjob

select cust, wm_conact(acc) as acc from table
group by cust

Is This Answer Correct ?

1 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we perform dml in function?

1071

What is information schema in sql?

1075

What are the basic sql commands?

1095

Can we use pl sql in mysql?

1016

What is compound trigger?

1043

What is auto increment?

1007

What are the two types of exceptions.

1172

How do you add a column to a table?

1056

When you have to use a default "rollback to" savepoint of plvlog?

1202

Is join same as left join?

1042

Is record in pl sql?

979

How can you know that statistics should be updated?

1079

How do I use google cloud in sql?

1093

How do you create a unique index?

1051

Explain table and field in sql?

1067