select cust, REPLACE(wm_conact(acc), ',', '|') as acc f

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

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

Answer Posted / bubun4u

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

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how mysql optimizes distinct? : Sql dba

1058

explain the delete statements in sql

1028

What is the purpose of a sql?

961

How can I see all tables in sql?

1045

define sql update statement ? : Sql dba

1099

What are the dml statements?

1129

What is field delimiter?

1034

how to run 'mysql' commands from a batch file? : Sql dba

1094

What is a null value?

1124

Describe types of sql statements?

1045

What is dml with example?

1065

Explain normalization and what are the advantages of it?

938

What are the various levels of constraints?

1114

Explain aggregate functions are available there in sql?

979

is it possible to pass an object or table to a procedure as an argument?

1105