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
Answer Posted / xxx
select 101 as 101,address1 from table1
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
How you will check the version of teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?
Explain the meaning of Amp?
How to Extract data from multiple legacy systems?
What are the functions of a Parser?
What is the difference between union and union all in teradata?
Explain teradata architecture?
how can we analyze the locks ?
How is MLOAD Client System restarted after execution?
How many codd's rules are satisfied by teradata database?
In the Primary Index, what is the score of AMPs that are actively involved?
What are the multiload utility limitations?
What do high confidence, low confidence and no confidence mean in explain plan?
Differentiate primary key and partition key?