select cust,wm_concate(acc) from table

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 / rajgopal

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

Answer Posted / rajgopal

select cust,wm_concate(acc) from table_name group by cust;

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Define a temp table?

1020

How do I create a sql database?

1003

How many sql databases can you have on one server?

1084

What is equi join in sql?

1078

How to select random rows from a table?

1076

Is microsoft sql free?

1105

What are sql queries used for?

1024

What is a database? Explain

1113

Can you do multiple joins in sql?

1053

Why do we use partitions in sql?

1051

what is 'mysqlcheck'? : Sql dba

1016

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

1061

What are triggers in sql?

1021

What are the advantages of sql? Explain

1107

How to take user input in pl sql?

1164