What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same?
Answer Posted / aditya shukla
Inner join-returns only matching row with equality or nonequality sign
equijoin-this also return matching row but only equal sign
Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What are types of scd? : sql server analysis services, ssas
How to create a view with data from multiple tables?
Which joins are sql server default?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What is the difference between left and right outer join?
How to change a login name in ms sql server?
What new changes are being made in SQL Server?
What is difference between group by and having?
What are the differences between stored procedure and the dynamic sql?
What is the difference between clustered and non-clustered indexes in ms sql server?
when you create a database how is it stored? : Sql server database administration
What is order of B+tree?
What is a primary key?
What are the advantages of partitioning?
Where in ms sql server is ’100’ equal to ‘0’?