Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is a recursive stored procedure in sql server?

1247


Can you pass expressions to function parameters?

1156


What do you understand by a stored procedure?

1154


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?

1085


What is cdc in sql server?

1046


Do you know the policy based administration feature of sql server 2008?

1004


what are the Prerequisites for Replication?

11445


How to connect a database with sql express.?

1119


Explain log shipping?

1078


Explain nested trigger in sql?

1131


What is the purpose of optimization?

1061


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

1001


Explain the difference between clustered and non-clustered index?

971


How to list all triggers in the database with sys.triggers in ms sql server?

1137


What is thr feature of change data capture?

1038