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
What is the contrast between sql and pl/sql?
How to make remote connection in database?
How exceptions can be handled in sql server programming?
What is the Control Flow in SSIS
What to check if a User database is locked?
Is resultset an interface?
Explain what is raid and what are different types of raid levels?
List out the differences between global and local temp tables in sql server?
What is the process of indexing?
Explain what is lock escalation?
What are the advantages to use stored procedures?
What is mssql?
Why normalization is used?
What is a fill factor?
what is the information that can be stored inside a bit column? : Sql server database administration