Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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