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
- 10631 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
Can we collect statistics on multiple columns?
What are the different table types supported by teradata?
Can you fastexport a field, which is primary key by putting equality on that key?
What are the frequently used data types in teradata?
Explain teradata architecture in detail with a diagram.
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Explain the advantages of partitioned primary index in a query?
Explain amp in teradata?
What are differences between teradata and ansi session modes in teradata?
What is the multi-insert?
What are the different design perspectives used in teradata?
In general, how do you optimze any sql in teradata?
What is the use of virtual processor connectivity in teradata?
What is dimensional modeling?
Explain fastload in teradata?
