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
- 13461 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 scenarios in which full table scans occurs?
Is multi insert ansi standard?
How to load specific no.of records using bteq, or fastload,or multiload
What are the uses of client software involved in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
How can you track login parameters of users in teradata?
Highlight the differences between Primary Key and Primary Index.
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What is the use of having index on table?
How many sessions of MAX is PE capable of handling at a particular time?
What are the enhanced features in teradata v2r5 and v2r6?
What are some commonly used bteq scripts?
What is a level of granularity of a fact table?
What is called partitioned primary index (ppi)?
Explain the term 'columns' related to relational database management system?
