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.
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
What is prepared statement in sql?
Can one improve the performance of sql*loader? : aql loader
What is a full join sql?
what is clause? : Sql dba
How to create an array in pl/sql?
Is time a data type in sql?
What do you mean by dbms? What are its different types?
What program will open a mdb file?
What is user in sql?
How many clustered indexes can be created on a table?
How bulk collect improves performance?
What is inner join in sql?
What is multiple columns?
What are triggers in sql?
how to increment dates by 1 in mysql? : Sql dba