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

What is Inner Join?

Question Posted / g.ramesh

Answers were Sorted based on User's Feedback



What is Inner Join?..

Answer / g.ramesh

Inner Join is default type of join.
It produce result set, which contain's only matched rows.

Is This Answer Correct ?    4 Yes 1 No

What is Inner Join?..

Answer / prasanna

Inner joins use a comparison operator(like = or <>)to match
rows from two tables based on the values in common columns
from each table.It is a default type of join.
These includes Equi Joins and Natural Joins.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

How do SQL server 2000 and XML linked?

2 Answers  

How to defragment indexes with alter index ... Reorganize?

0 Answers  

What are tasks?

3 Answers   Wipro,

What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

What are the difference between primary key and unique key? : sql server database administration

0 Answers  




what are the advanced features in sql 2008?

2 Answers   Wipro,

How can we use ConnectorJ JDBC Driver with MS SQL?

0 Answers   PUCIT,

How do I make a resultset scrollable?

0 Answers  

What does asynchronous call backs means?

0 Answers   Alcatel-Lucent,

How to change the data type of an existing column with "alter table" statements in ms sql server?

0 Answers  

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

Explain what are various ways to enhance the ssrs report?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories