say table1 has col1 & table2 has col1 column select col1 from table1

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

Question Posted / alka

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

Please Help Members By Posting Answers For Below Questions

What are the restraints imposed on the table design by a merge replication?

1038

Detail about query optimizer?

1103

How to call a function from a stored procedure in SQL Server ?

1029

What is Federation Root Database?

104

What are the new security features added in sql server 2012? : sql server security

1023

what is memory-optimized nonclustered indexes

1016

What are indexes in sql?

1281

What is microsoft sql server?

974

What are the steps to insert a table?

945

What is a dataset and what are the different types of datasets?

136

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1135

Explain Capacity planning to create a database? and how to monitor it?

4204

Explain DBCC?

960

last function used in MS Access to convert sql what function will use in sql

2070

How to copy the tables, schema and views from one sql server to another?

1047