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 / 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
Which is faster fastload or multiload?
What is meant by a Clique?
What are the advantages of teradata?
What exactly do you know about catching in teradata?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What are some primary characteristics of teradata?
Syntax for case when statement?
any one answer me how they can analyzing the project using data ware housing?
how many modules are there in telecome domain?how to explain the architecture?
what is sysdba and sysdbc ? which has high priority ?
What are normalization, first normal form, second normal form and third normal form?
What are the uses of bynets in multi-node systems?
What do high confidence, low confidence and no confidence mean in explain plan?
Explain the teradata primary index mechanics in detail with a diagram.
What is meant by a Highest Cost Plan?