Sign Up Login


  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

What are the types of database schema? : sql server analysis services, ssas

0 Answers  

Is BCNF better than 2NF & 3NF? Why?

0 Answers   Akamai Technologies,

What is index in an assignment?

0 Answers  

You are doing log shipping due to some reasons it is failing. How you will proceed from there

0 Answers  

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 Answers  




Explain the xml support sql server extends?

0 Answers  

What are Magic Table?

34 Answers   3i Infotech, Digiweb, Evalueserve, NIIT, PL,

What are group functions in query statements in ms sql server?

0 Answers  

How each E-R model constructs can be mapped to the relational model?

0 Answers   HCL,

Describe and explain about SQL native client?

0 Answers  

How to delete existing triggers using "drop trigger"?

0 Answers  

What is the difference between SSAS 2000 and SSAS 2005?

1 Answers   APX,

For more SQL Server Interview Questions Click Here
Categories