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

Answers were Sorted based on User's Feedback



Hi Friends I have a sql question, We have the source data as below. 101 address1, address2,..

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

Hi Friends I have a sql question, We have the source data as below. 101 address1, address2,..

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

Hi Friends I have a sql question, We have the source data as below. 101 address1, address2,..

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 Friends I have a sql question, We have the source data as below. 101 address1, address2,..

Answer / hari m

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

Hi Friends I have a sql question, We have the source data as below. 101 address1, address2,..

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

Hi Friends I have a sql question, We have the source data as below. 101 address1, address2,..

Answer / xxx

select 101 as 101,address1 from table1

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Teradata Interview Questions

Did you write stored procedures in teradata?

0 Answers  


What exactly do you know about catching in teradata?

0 Answers  


What are the components provided on node?

0 Answers  


i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table

6 Answers   Satyam,


What are the various indexes in teradata? How to use them?

0 Answers  


Does SDLC changes when you use Teradata instead of Oracle?

2 Answers  


If the table does not have duplicates then which utility you can suggest to load the data ?

3 Answers  


In the Primary Index, what is the score of AMPs that are actively involved?

0 Answers  


What is database exceptions in teradata?

0 Answers  


In general, how do you optimze any sql in teradata?

0 Answers  


what is meant by Hot amp?

2 Answers   IBM, Satyam,


What are the 5 phases in a multiload utility?

0 Answers  


Categories