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
- 9078 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
what are the differences between char and nchar? : Sql dba
What are the different types of dbms?
Does pl sql work in mysql?
What is difference between ms sql and mysql?
What is rowtype?
What is database sql?
What is a full join sql?
Write an sql query to select all records from the table?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What is program debugging?
What is the source code of a program?
What are stored procedures used for?
What is the difference between the sql*loader and import utilities? : aql loader
what is the difference between undefined value and null value? : Sql dba
What is substitution variable in pl sql?
