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 the difference between row_number and dense_rank?

827

Can you insert NULL in unique column?

1098

How would we use distinct statement? What is its use?

1024

Can You Use Data Mining Models In Ssrs?

139

Explain how you can configure a running aggregate in SSRS?

155

What are the advantages of having an index on the sql server?

874

How we can compare two database data?

875

Give me a SQL Query to find out the second largest company?

1122

What is #temp and @table variable in SQL server?

1027

What method is used by the Command classes to execute SQL statements that return single values?

1007

How to execute stored procedure and set temp table in sql server?

994

What is the difference between insensitive and scroll cursor?

1072

What is Transparent Data Encryption?

942

How to get the definition of a trigger back?

962

Explain having clause and where clause?

992