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
- 17326 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
What is scrollable cursor?
how to trace the traffic hitting a sql server? : Sql server database administration
How to write a query with a full outer join in ms sql server?
What is acid mean in sql server?
What is difference between foreign key and unique key?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Why truncate is ddl command?
What is bit data type? What's the information that can be stored inside a bit column?
Do you know the policy based administration feature of sql server 2008?
Can you force a query to use a specific index?
What is an index in a database?
What is the default order of an order by clause?
How to list all login names on the ms sql server?
What are the source of constraints?
What is spid in sql server profiler?
