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
- 15922 Views
- RBS, I also Faced
- E-Mail Answers
Answer Posted / alka
say table1 has col1 & table2 has col1 column
select col1 from table1
union
select col2 from table2
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
what data regions are and what are the different data regions?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
Can a rule be bound to any column of any data type?
What is the filtered index?
What are the different authentication modes in sql server? How can it be changed?
List out different types of normalizations in sql server and explain each of them?
What are the different types of locks in the database?
What are horizontal and vertical scaling?
List the different index configurations possible for a table?
Why would you use sql agent?
Can a trigger be created on a view?
How adventureworkslt tables are related?
List down some advantages of sql stored procedure?
What is ssrs?
What is merge join?
