Distinct

Table of Contents



SELECT DISTINCT removes duplicate rows from the results. Two rows are duplicates when every selected value is the same.

round-pushpin Returns each language id that is used by a word.
SELECT DISTINCT LanguageId FROM WordList:Word

round-pushpin Returns the distinct first letters of the words.
SELECT DISTINCT ToUpper(Left(Text, 1)) as Initial FROM WordList:Word

DISTINCT can be written before or after Top: SELECT DISTINCT TOP 10 removes duplicates before the limit is applied, and SELECT TOP 10 DISTINCT limits the rows before removing duplicates.



SQL :: Sha256Agg
Returns a single SHA-256 hash of all of the values in each group, as a lower case hex string. Useful for detecting changes to a set of documents.
SQL :: Sha512Agg
Returns a single SHA-512 hash of all of the values in each group, as a lower case hex string. Useful for detecting changes to a set of documents.
SQL :: Single
A built-in schema containing exactly one document, used to evaluate constant expressions.
SQL :: Sum
Returns the total of the values in each group.
SQL :: Top
The TOP keyword limits the number of results that are returned by a query.
SQL :: Variance
Returns the population variance of the values in each group: how far the values are spread from their mean.