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
- 12 Answers
- 14596 Views
- RBS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can we hide the definition of a stored procedure from a use?
Explain what is meant by replication of database?
What is the difference between for xml raw and for xml auto?
What are trace files?
What is the difference function and stored procedure?
Can a function call a stored procedure in sql server?
Is BCNF better than 2NF & 3NF? Why?
what's the information that can be stored inside a bit column? : Sql server database administration
How to provide login information for a new odbc dsn?
What is the sql case statement used for?
Distinguish between commit and rollback?
How to find out what is the default collation in a database?
What is table join?
What is the New in SQL server 2008?
What are the advantages of partitioning?
