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
12604 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

What is the use of having index on table?

1005

Explain Teradata performance tuning and optimization?

1171

What is called partitioned primary index (ppi)?

1013

What is collect statistics?

1004

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1171

Define views in teradata with general syntax.

1037

What do you mean by teradata sql assistant?

1065

Is multi insert ansi standard?

2212

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2122

What are the frequently used data types in teradata?

1086

How can you track login parameters of users in teradata?

1198

What is a sparse index?

1088

How do you set the session mode parameters in bteq?

1107

How does hashing happens in teradata?

1092

How do you determine the number of sessions?

1064