Min

Table of Contents

Returns the smallest numeric value in each group. Use MinString for text.

Numeric Min(AggregationArray valuesArray)

Groups the synonyms by source word and computes Min of the target word ids.

SELECT
    SourceWordId,
    Min(TargetWordId) as Result
FROM
    WordList:Synonym
GROUP BY
    SourceWordId