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

Hi Friends

I have a sql question, We have the source data as below.

101 address1, address2, address3

and the output shoulb like below

101 address1
101 address2
101 address3

Required a SQL query for this output.

Please let me know if you have any sql query for this.

Thanks in advance.

Hari M

Answer Posted / hari m

Hi Vennala

The posted query will work fine. But what if incase 'N'
no.of columns, like address1, address2..., address n.

The query will become lenghty with N no.of Unions.

Is there any script or procedure as alternative??

Please help me out in this regard.

Thanks,
Hari

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is faster fastload or multiload?

1179


What is meant by a Clique?

1114


What are the advantages of teradata?

1059


What exactly do you know about catching in teradata?

1080


Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2242


What are some primary characteristics of teradata?

1052


Syntax for case when statement?

1118


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

2522


how many modules are there in telecome domain?how to explain the architecture?

2064


what is sysdba and sysdbc ? which has high priority ?

3884


What are normalization, first normal form, second normal form and third normal form?

1110


What are the uses of bynets in multi-node systems?

1073


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

1098


Explain the teradata primary index mechanics in detail with a diagram.

1036


What is meant by a Highest Cost Plan?

1112