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
- 13471 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ronak
You have to use LPAD function,
Select lpad(address,20,'101')
from tableName;
NOTE: address is column name of address info, 20 is total
characters you want to display including 101 (since in this
case we don't know the characters of address),
Thank you
Ronak
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ksks
Make use of UNPIVOT to split one record into many rows:
select id,address from T1 unpivot (address for address_type in (address1,address2,address3))
| Is This Answer Correct ? | 1 Yes | 0 No |
Hi Vennala
The posted query will work fine. But what if incase 'N'
no.of columns, like address1, address2..., address n.
The query will become lenghty with N no.of Unions.
Is there any script or procedure as alternative??
Please help me out in this regard.
Thanks,
Hari
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / tdguy
Hi Hari,
IF the source data is present in a file, then it can
be handled in the supporting OS say unix or mainframe,
whichever is being used. But the input data is present in a
single column, then i think UDF has to be used.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the available primary index types?
how to delete duplicate records in multi set table without using any tables
2 Answers Accenture, Nest, South Nests Software Solution, Spiro Solutions,
Does any body has TERADATA Certification Dumps, if any body is having please let me know to summee4you@gmail.o, it is very Very URGENT to me
How is the teradata different from oracle?
Define views in teradata with syntax.
Differentiate database data and data warehouse data?
What is inner join and outer join?
Difference between Teradata V2R5 and Teradata V12 versions?
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
Comment whether bottleneck is an error or not.
In the Primary Index, what is the score of AMPs that are actively involved?
Why teradata is used?
Teradata 
