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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / rajuvem

Answers were Sorted based on User's Feedback



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 s..

Answer / guru

Union gives the result in two records

We have to use cross join like below



select * from table1,table2

Is This Answer Correct ?    0 Yes 8 No

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 s..

Answer / vivek

select col1,col2 from table1 union table2

Is This Answer Correct ?    0 Yes 14 No

Post New Answer

More SQL Server Interview Questions

How do I view a trc file?

0 Answers  

How to Run a Query on a Remote SQL Server?

2 Answers  

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

What is the difference between delete and truncate statements?

0 Answers  

What is efficiency data?

0 Answers  

Explain what is sql server english query?

0 Answers  

What are secondary xml indexes?

0 Answers  

how can a database be repaired? : Sql server administration

0 Answers  

How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?

1 Answers   GE,

What do you understand by triggers and mention the different types of it?

0 Answers  

What happens if the update subquery returns multiple rows in ms sql server?

0 Answers  

What is indexing in sql server with example?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories