“A little man often casts a long shadow.”
- Italian Proverb
An IN List is much like a Subquery
WHERE Dept_No IN(100, 200) ;
This query is very simple and easy to understand. It uses an IN List to find all Employees who are in Dept_No 100 or Dept_No 200.
An IN List Never has Duplicates – Just like a Subquery
What is going on with this IN List? Why in the world are their duplicates ...