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;

What is difference between hql and sql?

0 Answers  

---

How do I view output in sql developer?

0 Answers  

---

What is exception? What are the types of exceptions?

0 Answers  

---

How is data stored on a disk?

0 Answers  

---

Why stored procedures are faster than query?

0 Answers  

---

what is ref cursor in pl/sql?

3 Answers  

---

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

---

What is rownum?

0 Answers  

---

Does a user_objects view have an entry for a trigger?

0 Answers  

---

What is the best sql course?

0 Answers  

---

Which constraints we can use while creating database in sql?

0 Answers  

---

Explain locks? : Transact sql

0 Answers  

---