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
- 13312 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / hari m
Hi Vennala
The posted query will work fine. But what if incase 'N'
no.of columns, like address1, address2..., address n.
The query will become lenghty with N no.of Unions.
Is there any script or procedure as alternative??
Please help me out in this regard.
Thanks,
Hari
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why does varchar occupy 2 extra bytes?
What is the function of parser component in teradata?
Explain the new features of teradata?
What is the purpose of joins in teradata and what are the available join types?
What is primary index and secondary index?
What are the various etl tools in the market?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Why teradata is used?
What is the purpose of using case expression in teradata?
What is meant by a Highest Cost Plan?
Difference between star and snowflake schemas?
What is the purpose of upsert command?
What are the functions of a teradata dba?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
