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 / anil

select * from table1

union

select * from table2

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are commit and rollback in sql?

911


your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

962


How to generate create view script on an existing view?

975


What guidelines should be followed to help minimize deadlocks?

928


What is normalization of database? What are its benefits?

1011


What is partition in sql server?

1021


Is it true, that there is no difference between a rule and a check constraint?

1021


How extra digits are handled with numeric data type literals?

946


What is reference section?

985


What is purpose of normalization?

931


What is database mirroring?

1092


Which tcl commands are available on the sql server?

1059


What is the purpose of grouping data in a report?

942


What is difference between sql and sql server?

973


What is efficiency data?

940