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

Which join condition can be specified using on clause?

901

How delete all data from table in sql?

951

What has stored procedures in sql?

996

Why we use cross join?

891

what is 'mysqld'? : Sql dba

909

Why stored procedure is faster than query?

951

what are string data types? : Sql dba

975

Is sql a scripting language?

924

How many types of privileges are available in sql?

1286

How to prepare for oracle pl sql certification?

1012

Why do we use sql constraints? Which constraints we can use while creating database in sql?

973

What are joins in sql?

958

What is sql performance tuning?

868

What are the different types of joins in sql?

1659

what is a database? : Sql dba

1101