Answer Posted / 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;

How long will it take to learn pl sql?

946

---

What are aggregate functions in sql?

1169

---

What makes a good primary key?

1052

---

Why do we use view in sql?

976

---

What is dynamic query?

985

---

Write a sql select query that only returns each name only once from a table?

1026

---

Is it possible to update views?

970

---

Advantages and disadvantages of stored procedure?

1126

---

Define a temp table?

1029

---

What are the benefits of pl/sql packages?

1110

---

What is crud stand for?

1006

---

What are character functions in sql?

945

---

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

1016

---

What are the most important characteristics of pl/sql?

1169

---

What is union and union all keyword in sql?

1054

---