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

select col1,col2 from table1 union table2

Is This Answer Correct ?    0 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which sql server table is used to hold the stored procedure scripts?

1061


What is row_number()?

984


Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

905


Is sql server free?

918


explain how to create a new schema in a database? : Sql server database administration

1107


If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1033


How to rename an existing column with sql server management studio?

999


What languages bi uses to achieve the goal?

1002


sql database suspect We have a sql database that is showing as suspect. How can we recover?

1932


How do I debug a stored procedure in sql server?

1107


How to create an multi-statement table-valued function?

996


What is the use of sign function?

1124


why would you call update statistics? : Sql server database administration

1088


Why do we use trigger?

972


Explain activity monitors

1076