ALL Example - Analytics Database - Teradata Vantage

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;