Hi, Since the no of output columns is a variable, I think we may have

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 / yuvaevergreen

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

Please Help Members By Posting Answers For Below Questions

Differentiate database data and data warehouse data?

1161

How many tables can you join in v2r5?

1115

What are the advantages of teradata?

1057

Highlight the points of differences between the database and user in Teradata.

1159

What do you mean by fastexport in teradata?

1044

What do you mean by parsing?

1159

What interface is used to connect to windows based applications?

1167

What is bteq utility in teradata?

1023

Is multi insert ansi standard?

2249

Describe primary index in teradata. And what are the available primary index types?

1040

what is sysdba and sysdbc ? which has high priority ?

3882

What is the function of parser component in teradata?

1130

What are the functions performed by bynet?

1085

What are the updated features of teradata?

1088

Explain the most common data types used in teradata?

1123