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
Answer Posted / amit
select * from table1
union
select * from table2
| Is This Answer Correct ? | 21 Yes | 5 No |
Post New Answer View All Answers
What is a recursive stored procedure in sql server?
Can you pass expressions to function parameters?
What do you understand by a stored procedure?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What is cdc in sql server?
Do you know the policy based administration feature of sql server 2008?
what are the Prerequisites for Replication?
How to connect a database with sql express.?
Explain log shipping?
Explain nested trigger in sql?
What is the purpose of optimization?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Explain the difference between clustered and non-clustered index?
How to list all triggers in the database with sys.triggers in ms sql server?
What is thr feature of change data capture?