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
If RDBMS is halted what will you do ?
What is meant by a Least Cost Plan?
Explain teradata architecture in detail with a diagram.
What exactly do you know about catching in teradata?
What is the difference between fastload and multiload? Which one is faster?
Mention a few of the ETL tools that come under Teradata.
What are the multiload utility limitations?
Highlight the points of differences between the database and user in Teradata.
Describe the between keyword in teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What are the various reporting tools in the market?
What is the primary index in teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .