By default Equi-join is same as inner-equi-join .
Which one is not type of Outer Join ?
Which type of join retrieves the unmatched rows and matched from the left (1st)table and only matched rows from right(2nd) table ?
In Right Outer-Join retrieves the unmatched rows and matched from the LEFT
table and only matched rows from RIGHT table.
What type of joining we are using here?
SELECT * FROM EMP E INNER JOIN DEPT ON D WHERE E.DEPTNO=D.DEPTNO;
Which JOIN is a JOIN operation that creates an implicit join clause for you based on the common columns in the two tables being joined ?
If you want to select columns that have the same name in both emp and dept table table , which of the among is correct one
SELECT * FROM EMP E1,EMP E2 WHERE E1.JOB=E2.JOB;
What type of joining we are using here ?
Which of the following join is kown as Co-Related-Sub-query ?
Cross join jenerally generate cross product between two table. Each row of Table1 ,combined with each rows of Table2.