Hello Frndz,
I have a table named product as shown below:
product_id product_name
1 AAA
1 BBB
1 CCC
2 PPP
2 QQQ
2 RRR
Now my output should be:
product_id product_name_1 product_name_2 product_name_3
1 AAA BBB CCC
2 PPP QQQ RRR
- 4 Answers
- 11457 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
Hi,
Since the no of output columns is a variable, I think we
may have to write a SP or macro to get the desired output.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What happens when a node suffers a downfall?
Differentiate database data and data warehouse data?
Comment whether bottleneck is an error or not.
How will you solve the problem that occurs during update?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Difference between multiload and tpump?
What is partitioned primary index (ppi)?
Explain the teradata primary index mechanics in detail with a diagram.
What is the multi-insert?
Describe primary index in teradata. And what are the available primary index types?
During the Display time, how is the sequence generated by Teradata?
How to run a query in teradata?
What are the main components of teradata system?
What are the commands to make a new table, change a table and remove a table in teradata?
Highlight the points of differences between the database and user in Teradata.
