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
- 17818 Views
- RBS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is after dml trigger?
Explain about SQL server 2005?
How to enter comments in transact-sql statements?
Tell me when is the update_statistics command used?
Explain what is it unwise to create wide clustered index keys?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
How are the unique and primary key constraints different?
What are the advantages of stored procedure in sql server?
what protocol both networks use? : Sql server database administration
Can you get second highest salary from the table?
What are points to remember while using the fillfactor argument?
What xml support does the sql server extend?
What are the different acid properties?
What is service broker? : sql server database administration
How much space does sql server 2016 take?
