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

Answer Posted / vennela12

Hi Hari.....try this

select 101,address1 from tablet1
union all
select 101,address2 from tablet1
union all
select 101,address from tablet1

By
Vennela

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

2020

Define views in teradata with general syntax.

565

What is collect statistics?

581

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

1689

What is a clique?

580




What type of indexing mechanism do we need to use for a typical data warehouse?

608

What is the primary index in teradata?

579

What is teradata? Also, list out some of the primary characteristics of teradata.

573

How to select first n records in teradata?

603

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

1949

List out all forms of LOCKS that are available in Teradata.

544

What are the steps involved after the disk manager passes the request?

568

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

588

How do you see a ddl for an existing table?

566

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

650