Max

Table of Contents

Returns the largest numeric value in each group. Use MaxString for text.

Numeric Max(AggregationArray valuesArray)

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

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