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
Answer Posted / vaishnavi a
Thanks for ur response, i just gave a sample table with few
records, but in a real time scenario we have a table with
duplicates & there can be many products under a particular
prod_id.It is not that there should be only 3 products
under a prod_id , it could be even 50. wat could be an
optimised way of writing a query for this scenario??
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the functions of a Parser?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What do you mean by caching in teradata?
What is the meaning of Caching in Teradata?
Explain fallback in teradata?
Describe primary index in teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What can be achieved by using the teradata rdbms?
Explain the advantages of partitioned primary index in a query?
Explain teradata architecture?
How can bottlenecks be identified?
How to Extract data from multiple legacy systems?
In the Primary Index, what is the score of AMPs that are actively involved?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?