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
- 10812 Views
- MTS, I also Faced
- E-Mail Answers
Answer Posted / prathibha
select customer_id,
MAX(CASE WHEN RNK MOD 8 = 1 THEN ACCOUNT_NO ELSE '' END) ||
MAX(CASE WHEN RNK MOD 8 = 2 THEN ',' || ACCOUNT_NO ELSE '' END) ||
MAX(CASE WHEN RNK MOD 8 = 3 THEN ',' || ACCOUNT_NO ELSE '' END)
AS ACCOUNT_NO
FROM
(
select customer_id,account_no, rank() over (partition by customer_id order by account_no) as rnk
from customer_account ) TEMP
GROUP BY 1
The above query is tested and it works.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Can we rollback truncate?
Can delete statement be rollbacked?
what is schema? : Sql dba
how to start mysql server? : Sql dba
what is bcp? When does it used? : Sql dba
Can we use distinct and group by together?
Does group by remove duplicates?
what is collation? : Sql dba
define sql insert statement ? : Sql dba
what are the advantages of sql ? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
what are aggregate and scalar functions? : Sql dba
How do I remove duplicates in two columns?
what are all the common sql function? : Sql dba
