Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   Data Types and Expressions > Expression >

Including or Excluding Duplicates in the Row Set

The DISTINCT keyword restricts the argument to unique values from the specified column. The UNIQUE and DISTINCT keywords are synonyms.

The ALL keyword specifies that all values selected from the column or expression, including any duplicate values, are used in the calculation.

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]