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


Please Help Members By Posting Answers For Below Questions

How to check if stored procedure is running in sql server?

567


What is dynamic cursor in SQL SERVER?

633


What are alternate keys?

656


Explain use of expression builder.

647


What are different backups available in sql server?

688






What is the size of transaction log file?

569


What is catalog views?

703


What are the types of subquery?

632


What will be the maximum number of indexes per table?

627


What is the difference between a primary key and a unique key? Are they the same?

654


what are the important architecture components of SSRS?

98


How to attach adventureworkslt physical files to the server?

720


List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

169


To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

628


What is the difference between nvl and nvl2?

629