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
- 13498 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
how do you manage the production space. what are the proactive methods you can take ?
Define views in teradata with syntax.
What is difference between user and database in teradata?
What is the difference between teradata and basic rdbms?
Explain the term 'database' related to relational database management system?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Highlight the points of differences between the database and user in Teradata.
What are the various indexes in teradata? Why are they preferred?
What is a clique?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are the components used in smp and massively parallel processing (mpp) machines?
How to select first n records in teradata?
Can we collect statistics on table level?
What are the various indexes in teradata? How to use them? Why are they preferred?
How will you solve the problem that occurs during update?
