1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

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

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 exactly do you know about catching in teradata?

722

How do you do backup and recovery in teradata?

644

What are the advantages of teradata?

686

How to view every column and the columns contained in indexes in teradata?

671

What is the basic syntax for teradata select statement?

669




What does sleep function does in fast load?

704

Explain teradata vs. Redshift?

635

What are the frequently used data types in teradata?

670

What is the difference between teradata and basic rdbms?

640

Explain teradata architecture?

723

What are the newly developed features of Teradata?

664

What are the enhanced features in teradata v2r5 and v2r6?

794

If RDBMS is halted what will you do ?

1794

Explain the term 'primary key' related to relational database management system?

699

What do you mean by teradata intellicloud?

679