Example: Using IN/NOT IN with a List of Literals - Analytics Database - Teradata Vantage

This example shows the behavior of IN/NOT IN with a list of literals.

Consider the following table definition and contents:

   CREATE TABLE t (x INTEGER);
   INSERT t (1);
   INSERT t (2);
   INSERT t (3);
   INSERT t (4);
   INSERT t (5);