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
- 8598 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 to fetch alternate records from a table?
What is the usage of distinct keyword?
How do you determine the current isolation level? : Transact sql
What is a string data type in sql?
List and explain the different types of join clauses supported in ansi-standard sql?
Define overloaded procedure?
Can we use views in stored procedure?
Does sql view stored data?
Explain raise_application_error.
What is a table partition?
What is the most important ddl statements in sql are?
What is sql and explain its components?
What is multiple columns?
what is 'mysqlimport'? : Sql dba
difference between anonymous blocks and sub-programs.
