Hi Vennala The posted query will work fine. But what if incase 'N&#

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 / hari m

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain how spool space is used.

1070

How to select first n records in teradata?

1100

What can be achieved by using the teradata rdbms?

1031

What's the difference between timestamp (0) and timestamp (6)?

1182

What is meant by a Channel Driver?

1237

Why is the case expression used in teradata?

1071

What are the different table types supported by teradata?

958

Highlight the advantages of PPI(Partition Primary Index).

1072

Differentiate database data and data warehouse data?

1106

What are the uses of bynets in multi-node systems?

1027

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

1015

Explain the term 'columns' related to relational database management system?

1062

Can we collect statistics on multiple columns?

1061

If RDBMS is halted what will you do ?

2159

What are the various reporting tools in the market?

1060