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

What are the different types of a subquery?

1033

How do you use a while loop in pl sql?

997

Why cross join is used?

1060

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4000

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1008

What is difference between hql and sql?

1052

what is the difference between char_length and length? : Sql dba

1027

Is nosql relational?

926

What is sqlcommand?

1009

What is a primary key sql?

1033

How is data stored on a disk?

1004

Why do we use procedures?

940

What is a column in a table?

1106

explain access control lists. : Sql dba

980

What is the difference between union and union all command?

1061