select col1,col2 from table1 union table2

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 / vivek

Answer Posted / vivek

Is This Answer Correct ?

0 Yes

14 No

Please Help Members By Posting Answers For Below Questions

Which are the olap features?

917

Define tempdb database?

954

How to change the ownership of a schema in ms sql server?

1115

Explain the various types of concurrency problem?

1144

What is isolation levels?

975

What is the difference between row_number and dense_rank?

843

How to declare a cursor with "declare ... Cursor" in ms sql server?

996

How to recreate an existing index in ms sql server?

1008

Explain the disadvantages/limitation of the cursor?

923

What happens if the update subquery returns no rows in ms sql server?

1088

What is the difference between web edition and business edition?

111

What is co-related sub query?

990

What is the rdl file?

135

How to find tables without indexes?

1047

Do you know concepts and capabilities of sql server?

1019