Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10657 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
What are schema-level triggers?
what are the advantages and disadvantages of views in a database? : Sql dba
What is a loop in sql?
What are transaction and its controls?
What does t sql mean?
Explain unique key in sql.
What is user defined functions?
Who developed sql?
what are the type of locks ? : Sql dba
what is user defined functions? : Sql dba
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is the main difference between sql and pl/sql?
What do you mean by “trigger” in sql?
What is sqlcommand?
What do you mean by table in sql?
