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
- 13324 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / vennela12
Hi Hari.....try this
select 101,address1 from tablet1
union all
select 101,address2 from tablet1
union all
select 101,address from tablet1
By
Vennela
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What are the different table types that are supported by teradata?
Difference between inner join and outer join?
What does Amp contain and what are all the operations that it performs?
Explain the term 'row' related to relational database management system?
What is meant by a dispatcher?
What is meant by a Channel Driver?
What are the different design perspectives used in teradata?
Difference between star and snowflake schemas?
Describe the set operators in teradata.
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is spool space? Why do you get spool space errors?
What are the main components of teradata system?
What are the functions of a Parser?
What are the components used in smp and massively parallel processing (mpp) machines?
