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
- 8599 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
how to use case expression? : Sql dba
What is delimiter in pl sql?
What are the different types of database management systems?
How do I filter in sql profiler?
Why should I use postgresql?
explain the difference between bool, tinyint and bit. : Sql dba
What is record in pl sql?
How would you reference column values before and after you have inserted and deleted triggers?
what is user defined functions? : Sql dba
how to shutdown mysql server? : Sql dba
what are all the different normalizations? : Sql dba
What is faster join or subquery?
Why do we create stored procedures & functions in pl/sql and how are they different?
Is sql a scripting language?
What is the difference between an inner join and an outer join?
