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

Is it possible to create trigger on views?

1033


You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

1145


How to verify the port number of the sql server?

1256


Explain time data type in sal server 2008?

970


What do you understand by intent locks?

1063


What is attribute relationships, why we need it? : sql server analysis services, ssas

1032


what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1183


Disadvantages of the indexes?

1185


How do I find query history in sql server?

991


How do you improve the performance of a SQL Azure Database?

137


How to disconnect from a sql server using mssql_close()?

1171


What were the latest updates to SQL Azure service?

113


Differentiate between truncate vs delete in mssql?

1168


What triggers long term care?

1094


What are the components of sql server service broker?

1065