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 is Extended user-defined?
How to create an inline table-valued function?
How do I find the size of a sql server database?
What are the types of dml?
Explain about builtinadministrator?
What is cube dimension? : sql server analysis services, ssas
Can we use trigger new in before insert?
What happens to a statement batch if there is a compilation error?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
How to skip remaining statements in a loop block using continue statements?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
How to assign null values to variables or columns?
What is the difference between a function and a trigger?
How do clustered indexes store data?
Explain syntax for dropping triggers?