Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 13453 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
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Can you fastexport a field, which is primary key by putting equality on that key?
Explain vproc in teradata?
Which is faster fastload or multiload?
What are the different design perspectives used in teradata?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What are the advantages of teradata?
Which is more efficient group by or distinct to find duplicates?
What is the use of having index on table?
How do you verify a complicated sql?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
what is object level locking ? where do appear this type of locking ?
How do you see a ddl for an existing table?
What are the components provided on node?
