Answers were Sorted based on User's Feedback
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|
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|
What are the pre-defined functions in the sql server?
Explain what are commit and rollback in sql?
How will u find the query which is running in some other machine
what is call by value & call by reference ?
How to convert a numeric expression from one data type to another?
What are date and time data types in ms sql server?
How to create logins using windows Authentication mode?
How to create a trigger for insert only?
difference between truncate, delete aur drop?
How to create hyperlink from returned sql query ?
What is temporary table in sql server? Why we use temp table?
Write a code to select distinct records without using the DISTINCT keyword.