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 package in pl sql with an examples?

0 Answers  

---

define primary key & secondary key?

2 Answers  

---

How many columns should be in an index?

0 Answers  

---

Can we commit in trigger?

0 Answers  

---

What is sql dialect?

0 Answers  

---

what are all the different types of indexes? : Sql dba

0 Answers  

---

what is try_catch block in procedure

0 Answers  

---

What are the types of variable use in pl sql?

0 Answers  

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

How do you add a column to a table?

0 Answers  

---

What is substitution variable in pl sql?

0 Answers  

---

what is a trigger in mysql? : Sql dba

0 Answers  

---