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 teradata? What are some primary characteristics of teradata?
If a Node is busy what are the steps you can take to avoid ?
What are the steps involved in the process flow of the sql statement through channel attached system?
Describe the between keyword in teradata?
What is the purpose of upsert command?
What are the functions performed by bynet?
what are the day to day activities of teradata DBA ?
What are differences between teradata and ansi session modes in teradata?
How do you do backup and recovery in teradata?
While creating table my dba has fallback or no fallback in his ddl. What is that?
Explain Teradata performance tuning and optimization?
What are the newly developed features of Teradata?
What are the primary characteristics of the Teradata.
What are the commands to make a new table, change a table and remove a table in teradata?
What is multi insert?