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
- 12611 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 database exceptions in teradata?
What is the difference between fastload and multiload? Which one is faster?
What do high confidence, low confidence and no confidence mean in explain plan?
Explain the term 'primary key' related to relational database management system?
What are the string manipulation operators and functions associated with teradata?
What is the purpose of joins in teradata?
What are default access rights in teradata? What explicit right can be given to a user?
What exactly do you know about catching in teradata?
What are the design features involved in teradata?
What is basic teradata query language?
Explain parsing engine in teradata?
what are the day to day activities of teradata DBA ?
What happens when a node suffers a downfall?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Differentiate primary key and partition key?
