ALL specifies that duplicate values are to be returned when an expression is processed.
Syntax Element … |
Specifies … |
ALL |
that all rows, including duplicates, are to be returned in the results of the expression list. This is the default value. |
ALL is ANSI SQL:2011-compliant.