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
13494 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

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

973

If a Node is busy what are the steps you can take to avoid ?

2414

What are the steps involved in the process flow of the sql statement through channel attached system?

1104

Describe the between keyword in teradata?

1036

What is the purpose of upsert command?

1177

What are the functions performed by bynet?

1041

what are the day to day activities of teradata DBA ?

5819

What are differences between teradata and ansi session modes in teradata?

1175

How do you do backup and recovery in teradata?

1017

While creating table my dba has fallback or no fallback in his ddl. What is that?

1184

Explain Teradata performance tuning and optimization?

1159

What are the newly developed features of Teradata?

1025

What are the primary characteristics of the Teradata.

1151

What are the commands to make a new table, change a table and remove a table in teradata?

1132

What is multi insert?

1049