Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17811 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
How to make a column nullable?
How many cores do I need for sql server 2016?
What is the difference between varchar and varchar(max) datatypes?
How to defragment indexes with alter index ... Reorganize?
what is a join and explain different types of joins? : Sql server database administration
How to receive returning result from a query?
How to use linked server?
What are the different methods available under sqlcommand class to access the data?
How to return the date part only from a sql server datetime datatype?
What are the differences between local and global temporary tables?
What xml support does the sql server extend?
Can two tables share the same primary key?
What is the difference between count () and rowcount ()?
What are the two modes of authentication in sql server?
What are the advantages of policy management?
