Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12753 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
Why are oltp database designs not generally a good idea for a data warehouse?
How can you track login parameters of users in teradata?
What are the steps involved after the disk manager passes the request?
What is basic teradata query language?
Explain teradata utilities. What is multiload, fast load, tpump?
if collect stats but it show low confidence why?
What is smp and mpp platforms?
What is bteq utility in teradata?
Explain the most common data types used in teradata?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
How to select first n records in teradata?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
If a Node is busy what are the steps you can take to avoid ?
What is meant by a Virtual Disk?
