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

What is difference between commit and rollback when used in transactions?

946

What is a derived table?

911

What does sql server mean?

1034

What is the difference between lock, block and deadlock? : sql server database administration

1024

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

923

How do triggers work?

917

How to convert binary strings into integers in ms sql server?

1006

Explain how you can deploy an SSRS report?

146

Do you know what is openxml in sql server?

1051

How will you go about resolving deadlocks?

950

Why would you call update statistics?

997

What are the properties of sub-query?

1061

What is sql sandbox in sql server?

1193

how you can get the list of largest tables in a database? : Sql server administration

1028

How does the report manager work in SSRS?

148