There is a table1 with records (1,2,3,4,5,6) and table2
with records (4,5,6,7,8,9).write a query so as to get the
result as 1,2,3,4,5,6,7,8,9
Answers were Sorted based on User's Feedback
Answer / john
select * from table1
union
select * from table2
-- Union will give distinct value of both tables
Is This Answer Correct ? | 38 Yes | 2 No |
Answer / alka
say table1 has col1 & table2 has col1 column
select col1 from table1
union
select col2 from table2
Is This Answer Correct ? | 8 Yes | 4 No |
Answer / sushama kumari
select col1,col2 from table1 union table2 is an incorrect
answer.
Following 2 are corrcet answers:
1.
select * from table1
union
select * from table2
2.
select col1 from table1
union
select col2 from table2
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / aparna
here is some thing diff answer ..
we can use full outer join...if they ask for other then
union condition..
select * from t1 full outer join t2 where t1.id= t2.id..
with some condition
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / naveen
For Oracle it would be
select * from table1
union all
select * from table2
if you will use
select * from table1
union
select * from table2
it will give you double rows those are common in both the
tables.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / jagadeesh
select isnull(a.id,b.id) from table1 a
full outer join table2 b
on a.id=b.id
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / goutam dey
its very easy yaar who has written this?
just use union operator as in set theory in mathematics
hahaha...
Is This Answer Correct ? | 1 Yes | 7 No |
what is the main difference between after trigger and instead trigger.
What is temporary stored procedure?
what is syntex second or third highest salary. thanks & Regards Dhirendra sinha
What are SQL Jobs, please mention the use of it and how to create them.
What is collation?
What are partitioned views?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
Does partitioning help performance?
What is cursors? And what are the different types of cursor?
What is Inner Join?
How to Check if table exists in sql server?