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
Explain primary key?
What is resource governor in sql server?
Where is localdb stored?
What is the difference between Clustered and Non-Clustered Index?
What is the data tier application?
what method you can use to reduce the overhead of Reporting Services data sources?
What is a document index?
What does truncate do?
which table keeps the locking information? : Sql server administration
What does it mean if @@cursor_row returns a negative number?
What are logical database components? : SQL Server Architecture
Can we install sql server 2016 on windows 7?
What are partitioned views?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
What are the different types of subquery?