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
- 13296 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / ksks
Make use of UNPIVOT to split one record into many rows:
select id,address from T1 unpivot (address for address_type in (address1,address2,address3))
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What type of indexing mechanism do we need to use for a typical data warehouse?
What is the difference between fastload and multiload? Which one is faster?
What do you mean by teradata sql assistant?
How is MLOAD Teradata Server restarted after execution?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
any one answer me how they can analyzing the project using data ware housing?
Define views in teradata with general syntax.
When tpump is used instead of multiload?
What is dimensional modeling?
What are the joins in teradata and how many types of joins are there in teradata?
What is partitioned primary index (ppi)?
Explain teradata utilities. What is multiload, fast load, tpump?
What does sleep function does in fast load?
if collect stats but it show low confidence why?
Highlight the need for Performance Tuning.
