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
What is similarity and difference between truncate and delete in sql?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
Is the log file is a part of file group?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What functions can a view be used to performed?
Explain Normalization and DE normalization
What are extended events in sql server?
How can we migrate from SQL server to SQL Azure?
What is BLOCK statements in SQL?
what purpose does the model database serve? : Sql server database administration
What is transaction server distributed transaction?
What is the maximum size of column in sql server?
How to modify the underlying query of an existing view?
What is the difference between a local and a global temporary table?
How to rename an existing column with sql server management studio?