What is Inner Join?

Question Posted / g.ramesh

2 Answers
5273 Views
I also Faced
E-Mail Answers

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

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

0 Answers

What are the different types of columns types constraints in the sql server?

0 Answers

What is transaction server auto commit?

0 Answers

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers TCS,

Can we call stored procedure in view in sql server?

0 Answers

Benefits of Stored Procedures?

0 Answers Wipro,

What is replace and stuff function in sql server?

0 Answers

Differentiate between delete and truncate.

0 Answers

What does select 1 mean?

0 Answers

What the different types of Replication and why are they used?