MaxString

Returns the alphabetically largest value in each group.

String MaxString(AggregationArray valuesArray)

Returns the last word of each language alphabetically.

SELECT LanguageId, MaxString(Text) as Last FROM WordList:Word GROUP BY LanguageId

• Group By
• Aggregate Functions