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

say table1 has col1 & table2 has col1 column

select col1 from table1
union
select col2 from table2

Is This Answer Correct ?    8 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me extended events in sql server 2008?

1055


do you know how to configure db2 side of the application? : Sql server database administration

1101


How to get the query of a table in sql server?

965


What is snapshot replication?

1102


What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

1045


how many no of arguments can be passed in procedures and functions

5643


How to use subqueries with the in operators in ms sql server?

1126


Is there any difference between the primary key and unique key?

1046


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

2256


How do I clean up sql server transaction log?

1127


What are the different types of replication are there in sql server 2000?

1090


Can you roll back the ddl statement in a trigger?

1021


How to enter comments in transact-sql statements?

990


How to identify current user in ssrs report?

408


what is sql server? : Sql server database administration

1045