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
- 13693 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
What are the various etl tools in the market?
What is the difference between teradata and basic rdbms?
What are the joins in teradata?
Highlight the differences between Primary Key and Primary Index.
What is a clique?
In the Primary Index, what is the score of AMPs that are actively involved?
Comment whether bottleneck is an error or not.
Explain the term 'row' related to relational database management system?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
How does hashing happens in teradata?
What are the joins in teradata and how many types of joins are there in teradata?
Which is more efficient group by or distinct to find duplicates?
What are the uses of bynets in multi-node systems?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What is multi insert?
