Also, use order by clause with union

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

Answer Posted / meghag

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we install sql server 2016 on windows 7?

1135

What will happen if a column containing char type data is changed to the nchar data type?

1103

How many levels of sp nesting are possible?

1028

Can a synonym name of a table be used instead of a table name in a select statement?

1032

What does sql server mean?

1070

How many databases instances are there in sql server 2000?

1098

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1137

Explain how you can deploy an SSRS report?

150

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1010

What are various aggregate functions that are available?

983

Define inner join in sql server joins?

1061

How extra digits are handled with numeric data type literals?

967

How to create view in stored procedure sql server?

1017

How self join is different from outer join?

1120

How do I find sql server instance name?

963