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
- 6 Answers
- 13460 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
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
What are some commonly used bteq scripts?
Describe primary index in teradata. And what are the available primary index types?
What is teradata? Also, list out some of the primary characteristics of teradata.
What are the steps involved after the disk manager passes the request?
Explain the advantages of partitioned primary index in a query?
Syntax for case when statement?
If RDBMS is halted what will you do ?
Highlight the differences between Primary Key and Primary Index.
How will you solve the problem that occurs during update?
List out all forms of LOCKS that are available in Teradata.
What are the string manipulation operators and functions associated with teradata?
What is meant by a node?
What is smp and mpp platforms?
What are the main components of teradata system?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
