Thanks for ur response, i just gave a sample table with few records, but

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

Question Posted / vaishnavi a

4 Answers
12422 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

Please Help Members By Posting Answers For Below Questions

Explain teradata architecture?

1033

List the logical and conditional operators that are used with teradata along with their meanings?

944

Different phases of multiload?

941

How do you set the session mode parameters in bteq?

1037

What are the 5 phases in a multiload utility?

987

What is difference between user and database in teradata?

1027

What do high confidence, low confidence and no confidence mean in explain plan?

984

Name the five phases that come under MultiLoad Utility.

930

What do you mean by fastexport in teradata?

942

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

962

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

2152

any one answer me how they can analyzing the project using data ware housing?

2412

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1728

Explain and compare pros and cons of start schemas?

978

What do you mean by teradata intelliflex?

1041