Interested to Buy Any Domain ? << Click Here >> for more details...
. 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.
CUST ACC
a dv
b fg
b bh
c mk
c cl
c so
result:-
A B c
dv fg mk
bh cl
so
- 3 Answers
- 6360 Views
- I also Faced
- E-Mail Answers
Answer Posted / phanikumar kode
select cust,listagg(acc,' ') within group(order by acc) from tbl group by cust;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain clause in sql?
How do I edit a stored procedure?
How do you rename a table in sql?
Why partition by is used in sql?
When can we use the where clause and the having clause?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
What are the different types of joins in sql?
Which constraints we can use while creating database in sql?
What does plv msg allows you to do?
What is the difference between syntax error and runtime error?
What are the disadvantages of file system?
Why is nosql good?
Is it mandatory for the primary key to be given a value when a new record is inserted?
What is sql catalog?
Is left join faster than inner join?
