What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same?
Answer Posted / ankita pandey
Equi Join -- Join performed in two tables having a common columna
with shared values in two tables by applying a where condition.
inner Join- Join performed in the same table itself(self join).
| Is This Answer Correct ? | 3 Yes | 19 No |
Post New Answer View All Answers
How to delete database objects with "drop" statements in ms sql server?
What is a fill factor?
What is the use of RDBMS?
How to download and install the scaled-down database adventureworkslt?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How do I view a script in sql server?
What options are available to audit login activity? : sql server security
difference between Clustered index and non clustered index ?
What do you mean by a dependent functionality in a build?
How to disable a login name in ms sql server?
What are orphan records?
Explain trigger and trigger types?
How to delete all rows with truncate table statement in ms sql server?
define and explain the differences between clustered and non-clustered indexes.
Explain transaction isolation levels in sql server?