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 / meghag
Also, use order by clause with union
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is it possible to create trigger on views?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
How to verify the port number of the sql server?
Explain time data type in sal server 2008?
What do you understand by intent locks?
What is attribute relationships, why we need it? : sql server analysis services, ssas
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
Disadvantages of the indexes?
How do I find query history in sql server?
How do you improve the performance of a SQL Azure Database?
How to disconnect from a sql server using mssql_close()?
What were the latest updates to SQL Azure service?
Differentiate between truncate vs delete in mssql?
What triggers long term care?
What are the components of sql server service broker?