What are Anti joins
Answer / vivek
Anti-joins:
Anti-joins are written using the NOT EXISTS or NOT IN
constructs. An anti-join between two tables returns rows
from the first table for which there are no corresponding
rows in the second table. In other words, it returns rows
that fail to match the sub-query on the right side.
Suppose you want a list of departments with no employees.
You could write a query like this:
SELECT d.department_name
FROM departments d
MINUS
SELECT d.department_name
FROM departments d, employees e
WHERE d.department_id = e.department_id
ORDER BY department_name;
The above query will give the desired results, but it might
be clearer to write the query using an anti-join:
SELECT d.department_name
FROM departments d
WHERE NOT EXISTS (SELECT NULL
FROM employees e
WHERE e.department_id = d.department_id)
ORDER BY d.department_name;
Is This Answer Correct ? | 17 Yes | 3 No |
How many types of index are there?
Why is normalization important?
How many types of cursors are available in pl/sql?
How can triggers be used for the table auditing?
what is the difference between union and union all? : Sql dba
What is procedure explain with example?
How do you change a value in sql?
how would concatenate strings in mysql? : Sql dba
What is a sql driver?
In pl/sql, what is bulk binding, and when/how would it help performance?
What are different types of sql?
Why coalesce is used in sql?