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 is the web service used for reporting services?

126

What is the difference between ddl and dml?

1064

What is the federation in sql azure?

What protocol does sql server use?

950

What is the difference between for auto and for nested?

1021

Where cross join is used?

973

How to disconnect from a sql server using mssql_close()?

1120

Differentiate between sql temp table vs table variable?

887

Mention the 3 ways to get a count of the number of records in a table.

987

What is snapshot replication?

1062

What is dirty read?

1091

What is scan table/view and seek table/view when its occurs? : sql server database administration

1063

What are the types of database schema? : sql server analysis services, ssas

1145

User wants only to display only pdf as export option in report manager. How to achieve this?

265

Is it possible to have clustered index on separate drive from original table location?

974