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
- 13695 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 steps involved in the process flow of the sql statement through channel attached system?
Explain vproc in teradata?
Explain and compare pros and cons of snow flake schemas?
Why does varchar occupy 2 extra bytes?
what is object level locking ? where do appear this type of locking ?
What is spool space?
What are tpump utility limitations?
What are the various indexes in teradata?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
If a Node is busy what are the steps you can take to avoid ?
If RDBMS is halted what will you do ?
What are the available join types in teradata?
What are the functions of a teradata dba?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
