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

Explain what is log shipping?

1192

Tell me when is the update_statistics command used?

1200

What is report subscription?

132

What is purpose of normalization?

998

Introduction of rollup clause using sum and group by clause?

1011

What is the difference between Triggers and Stored Procedure?

1156

Explain how would you store your query in an SSRS report or a Database server?

133

What is difference between Datepart() and Datename() in SqlServer?

1257

List out a number of the wants to setup a SQL Server failover cluster?

1122

How to update muliple row in single query?

1113

List the different normalization forms?

1021

Define synonym?

1222

What happens if you add a new index to large table?

982

What is rs.exe utility?

164

What is the difference between DataRow.Delete() and DataRow.Remove()?

1272