select 101 as 101,address1 from table1

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 / xxx

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

Answer Posted / xxx

select 101 as 101,address1 from table1

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Did you write stored procedures in teradata?

1060

any one answer me how they can analyzing the project using data ware housing?

2407

Which is more efficient group by or distinct to find duplicates?

1036

What are the primary characteristics of the Teradata.

1058

What is teradata? What are some primary characteristics of teradata?

929

What is meant by a Virtual Disk?

1047

What are the enhanced features in teradata v2r5 and v2r6?

1079

What are some commonly used bteq scripts?

945

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1662

How would you load a very large file in teradata in general?

969

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

935

Is multi insert ansi standard?

2147

What are the advantages of teradata?

958

How do you do backup and recovery in teradata?

962

What is meant by a Clique?

989