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
- 12739 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 is the purpose of upsert command?
What is called partitioned primary index (ppi)?
Explain amp in teradata?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is spool space? Why do you get spool space errors?
Highlight the need for Performance Tuning.
What happens in a conflict? How do you handle that?
What is basic teradata query language?
What is TPD?
Syntax for case when statement?
What do you mean by teradata intelliflex?
What is meant by a Virtual Disk?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Explain the term 'row' related to relational database management system?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
