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
- 9079 Views
- MTS, I also Faced
- E-Mail Answers
Answer Posted / trainedforjob
select cust, wm_conact(acc) as acc from table
group by cust
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
How do I find sql profiler?
What is the difference between having clause and where clause?
How much does a sql dba make? : SQL DBA
How much ram can sql express use?
What is the difference between python and sql?
how many groups of data types? : Sql dba
how many columns can be used for creating index? : Sql dba
What is the difference between the conventional and direct path loader? : aql loader
What is pragma in pl sql?
How to Declare Fixed Length String Value In PL SQL
What is keys and its types?
Difference between truncate, delete and drop commands?
What is bind reference and how can it be created?
What does stand for in sql?
Why do we use partitions in sql?
