ALL Example - Advanced SQL Engine - Teradata Database

In contrast to the second statement in Example: Simple Uses of DISTINCT, this statement returns the department number for every employee:

     SELECT ALL dept_no
     FROM employee;