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;

Is left join faster than inner join?

1125

---

Do prepared statements prevent sql injection?

952

---

What is function and procedure in pl sql?

1046

---

What is difference between sql and excel?

1095

---

How do I create an index in word?

1034

---

What are the two types of exceptions.

1171

---

how can we submit a form without a submit button? : Sql dba

988

---

Are sql database names case sensitive?

1006

---

Can two tables have same primary key?

976

---

what is try_catch block in procedure

1750

---

How do you pronounce sql?

1013

---

Does execute immediate commit?

1221

---

What is dbo in sql?

963

---

What are different types of statements supported by sql?

1165

---

What is the difference between inner join and natural join?

1007

---