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

can foreign key take role of primary key?

5 Answers   CarrizalSoft Technologies, TCS, Villa Marie,

Explain data warehousing in sql server?

0 Answers  

How to delete duplicate rows in sql server?

0 Answers  

What is the security principal at the server level that represents your session?

0 Answers  

Define left outer join?

0 Answers  




What is the difference between DATETIME2 and DATETIME?

0 Answers   Infosys,

How to delete exactly duplicate records from a table?

0 Answers  

Does a sql server 2005 select statement require a from?

0 Answers  

Do you have any idea about the tcl commands?

0 Answers  

What is page-level compression?

0 Answers  

What do you mean by table and field in sql?

0 Answers  

what are the advanced features in sql 2008?

2 Answers   Wipro,

For more SQL Server Interview Questions Click Here
Categories