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 deploy, process and build? : sql server analysis services, ssas
What are partitioned views?
What are the various editions of sql server 2017 that are available in the market?
What are the restrictions that views have to follow? : SQL Server Architecture
What is the difference between clustered index and primary key?
What is database black box testing?
What is filestream?
How to get the definition of a stored procedure back?
Which language is supported by sql server?
What is mean by candidate key?
Is a primary key unique?
What are the methods used to protect against sql injection attack?
Write a sql query to display the current date?
What are commonly used odbc functions in php?
Find nth lowest salary or get nth lowest salary?