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
- 13220 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
what are the day to day activities of teradata DBA ?
What is the command in bteq to check for session settings ?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Discuss the advantages of using partitioned primary index in a query?
what are the uses of fact table and dimension table in banking project?
How do you see a ddl for an existing table?
What is a level of granularity of a fact table?
How can you track login parameters of users in teradata?
What is the difference between fastload and multiload? Which one is faster?
Explain the term 'tables' related to relational database management system?
Mention a few of the ETL tools that come under Teradata.
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Highlight the differences between Primary Key and Primary Index.
What is teradata and why it is used?
What is bteq utility in teradata?
