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
13316 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 sysdba and sysdbc ? which has high priority ?

3788

What are default access rights in teradata? What explicit right can be given to a user?

1079

how many modules are there in telecome domain?how to explain the architecture?

1984

What does Amp contain and what are all the operations that it performs?

968

What do high confidence, low confidence and no confidence mean in explain plan?

1005

What is primary index and secondary index?

992

What do you mean by parsing?

1076

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3337

What is the syntax for case when statement?

1085

How to identify ppi columns?

1133

What is partitioned primary index (ppi)?

1020

Name the five phases that come under MultiLoad Utility.

947

Explain fallback in teradata?

1008

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

1022

What is called partitioned primary index (ppi)?

978