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

Hi Hari,
IF the source data is present in a file, then it can
be handled in the supporting OS say unix or mainframe,
whichever is being used. But the input data is present in a
single column, then i think UDF has to be used.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If RDBMS is halted what will you do ?

2220


What is meant by a Least Cost Plan?

1106


Explain teradata architecture in detail with a diagram.

1164


What exactly do you know about catching in teradata?

1078


What is the difference between fastload and multiload? Which one is faster?

1296


Mention a few of the ETL tools that come under Teradata.

1131


What are the multiload utility limitations?

1112


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

1160


Describe the between keyword in teradata?

1081


tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

901


What are the various reporting tools in the market?

1115


What is the primary index in teradata?

1279


Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

2000


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1157


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

1824