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

What is a fill factor?

822


What do you understand by the data quality services in sql server?

699


can SSRS reports Cache results?

127


What do you know about system database? : SQL Server Architecture

675


If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

753






You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

718


How would you add a section to a table?

777


How the authentication mode can be changed?

846


How do you manipulate data?

666


How to generate create procedure script on an existing stored procedure?

694


What is Transparent Data Encryption?

736


How to read data in a table with "select" statements?

736


Define inner join in sql server joins?

716


How do you delete a data source?

753


How to create a new login name in ms sql server?

704