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
- 17662 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 return the date part only from a sql server datetime datatype?
Difference between Logical Page and Physical Page in SSRS.
What are the lambda triggers?
Describe in brief sql server monitoring ways.
List some of the rules that apply to creating and using a ‘view’
What is a data source file?
Explain aggregate functions?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
Write a sql query to get zero records from a table having n number of records?
What are the advantages of using third-party tools?
How to make conditional sum in ssrs?
What is transaction server consistency?
What is table constraint?
Explain differences between web edition and business edition?
Is a primary key unique?
