What is Inner Join?

Question Posted / g.ramesh

2 Answers
5265 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

how to delete duplicate rows from table in sql server

12 Answers HCL, UHG,

What Is The Difference Between Primary Key & Super Key

3 Answers Accenture,

Explain transaction server implicit?

0 Answers

What is join and name different type of joins?

0 Answers

Do you know what are the ways available in sql server to execute sql statements?

0 Answers

what is the disadvantage of SQL Loder?

1 Answers TCS,

Why foreign key column allowing null values even a parent tables reference key column not having null value..

2 Answers IBM,

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 Answers

How to use go command in "sqlcmd"?

0 Answers

what is web server?

3 Answers Satyam,

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

7 Answers ADP, Satyam, Tech Mahindra,

what's sql server? : Sql server database administration

0 Answers

For more SQL Server Interview Questions Click Here