What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same?
Answer Posted / mobin sathupally
All are same.
Eg:
SELECT
*
FROM Emp INNER JOIN Emp1
ON eid=id
SELECT
*
FROM Emp EQUI JOIN Emp1
ON eid=id
SELECT
*
FROM Emp NATURAL JOIN Emp1
ON eid=id
| Is This Answer Correct ? | 18 Yes | 71 No |
Post New Answer View All Answers
Does full backup break log chain?
What is the difference between push and pull subscription? : sql server replication
What are the differences between stored procedure and view in sql server?
What is read uncmmited?
What are orphan records?
What is the order by used for?
What are different types of roles provided by ssrs?
What are extended events in sql server?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Mention what are the different types of ssrs reports?
List some advantages and disadvantages of stored procedure?
What is hot add cpu in sql server 2008?
What do you mean by an execution plan? Why is it used?
What is normalization? Explain different forms of normalization?
What is pessimistic concurrency?