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
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What are the string manipulation operators and functions associated with teradata?
How do you define Teradata?
While creating table my dba has fallback or no fallback in his ddl. What is that?
How can we check the version of Teradata that we are using currently?
Explain the term 'database' related to relational database management system?
Highlight the advantages of PPI(Partition Primary Index).
How do you create tables? Exact syntax, and create profiles, users in teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
In Teradata, how do we Generate Sequence?
What is logical data model?
Define views in teradata with syntax.
What are teradata utilities?
What are the frequently used data types in teradata?