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
- 13506 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
What are the main components of teradata system?
What are the various reporting tools in the market?
In Teradata, what is the significance of UPSERT command?
What is the purpose of indexes?
Which is more efficient group by or distinct to find duplicates?
What do you mean by fastexport in teradata?
How you will check the version of teradata?
What is database exceptions in teradata?
What is the opening step in basic teradata query script?
What are the various etl tools in the market?
What is the difference between fastload and multiload?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
In general, how do you optimze any sql in teradata?
What are the joins in teradata and how many types of joins are there in teradata?
What are the functions involved in shared information architecture?
