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
- 15330 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 is the report builder?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
Do you know sql server 2008 introduces automatic auditing?
What is difference in performance between insert top (n) into table and using top with insert?
What is sqlservr.exe - process - sql server (sqlex?press)?
What is outer join in sql server joins?
What happens if you are trying to access a schema not owned by you?
What is the purpose of grouping data in a report?
Which table keeps the locking information?
Explain microsoft sql server functions?
What is the temp table?
Why do we partition data?
What are various ways to enhance the ssrs report?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
