What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same?

Answer Posted / jitendra mali

The equi join is retrived selected column from the both
the table
or
The inner join is only retrived selected column from the table

Is This Answer Correct ?    6 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

578


What is named calculation? : sql server analysis services, ssas

535


What is the difference between ddl and dml?

572


What is partition index in sql server?

610


What is the filtered index?

563






How to create a view with data from multiple tables?

561


Does windows server 2016 come with sql server?

505


What are the difficulties faced in cube development? : sql server analysis services, ssas

611


What is the default sql server instance name?

560


What are different types of schemas?

523


Explain nested trigger in sql?

597


What is a partition function in sql server?

537


What is blocking and how would you troubleshoot it? : sql server database administration

595


what are the different ways to return the rowcount of a table?

579


How to delete duplicate rows?

557