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.
- 7 Answers
- 8607 Views
- MTS, I also Faced
- E-Mail Answers
Answer Posted / kpk
select cust,wmsys.wm_concat(acc) from tbl group by cust;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use sql*plus built-in timers?
how to drop an existing table in mysql? : Sql dba
What does select * from mean in sql?
Define the select into statement.
what is the command used to fetch first 5 characters of the string? : Sql dba
Compare sql & pl/sql
What is on delete set null?
What is the use of index in hive?
What does trigger mean in psychology?
What is use of trigger?
What is write ahead logging in sql server?
How do you write an inner join query?
What is the use of pl/sql table?
What are sql constraints?
Is sql difficult?
