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
- 17309 Views
- RBS, I also Faced
- E-Mail Answers
Answer Posted / anil
select * from table1
union
select * from table2
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Can we perform backup restore operation on tempdb?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What are examples of triggers?
What are the differences between lost updates and uncommitted dependencies?
What are the types of ssrs?
Give me a SQL Query to find out the second largest company?
What is the difference between commit and rollback?
Define constraints and give an example of their use?
What is an indexing strategy?
What is a primary key?
Define candidate key, alternate key, and composite key.
What kind of problems occurs if we do not implement proper locking strategy?
What is a non equi join?
What is sql server profiler trace data file?
What is user-defined scalar function?
