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
- 13233 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
How do you verify a complicated sql?
What are tpump utility limitations?
How can bottlenecks be identified?
What are the advantages of teradata?
What is meant by a Parsing Engine?
What is spool space?
What are normalization, first normal form, second normal form and third normal form?
What are the functions involved in shared information architecture?
Syntax for case when statement?
If a Node is busy what are the steps you can take to avoid ?
Explain the term 'row' related to relational database management system?
Highlight the differences between Primary Key and Primary Index.
Why is the case expression used in teradata?
What is the difference between union and union all in teradata?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
