Make use of UNPIVOT to split one record into many rows: select id,address

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

Question Posted / ksks

6 Answers
13690 Views
JPMorgan Chase, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are tpump utility limitations?

1176

Highlight all the modes that are present under Confidence Level.

1009

What is the opening step in basic teradata query script?

1090

Explain the teradata primary index mechanics in detail with a diagram.

1036

What are the different softwares used with their functions in teradata?

1060

What is primary index and secondary index?

1066

How to select first n records in teradata?

1159

Can you fastexport a field, which is primary key by putting equality on that key?

1228

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2242

What are the primary characteristics of the Teradata.

1236

When tpump is used instead of multiload?

1142

How many tables can you join in v2r5?

1115

Why managing the data is important?

1056

What is meant by a Virtual Disk?

1205

Explain the parallel data extension in teradata?

1150