select cust,listagg(acc,' ') within group(order by acc) from &nbs

. 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

Question Posted / phanikumar kode

3 Answers
6351 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

Please Help Members By Posting Answers For Below Questions

Can there be 2 primary keys in a table?

997

What is difference between ms sql and mysql?

963

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2113

What is int identity in sql?

1141

Differentiate between % rowtype and type record.

1303

what is an alias command? : Sql dba

1112

What are different functions in sql?

946

explain mysql aggregate functions. : Sql dba

989

what is auto increment? : Sql dba

1008

What are the two types of exceptions in pl/sql?

1052

what tools available for managing mysql server? : Sql dba

1085

What is record in pl sql?

1083

What is attribute indicator in pl sql?

1013

What is record data type?

916

Explain what is an index?

1056