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.
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
how to drop an existing view in mysql? : Sql dba
what are the features and advantages of object-oriented programming? : Sql dba
What is difference between primary and secondary key?
Can sql function call stored procedure?
What is pl sql record in oracle?
What are operators available in sql?
How to get help at the sql prompt?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Why having clause is used in sql?
What is a boolean in sql?
What is pl sql block in dbms?
Can we join 3 tables in sql?
Is sql better than excel?
Is hadoop a nosql?
Is sql a oracle?