MinString

Returns the alphabetically smallest value in each group.

String MinString(AggregationArray valuesArray)

Returns the first word of each language alphabetically.

SELECT LanguageId, MinString(Text) as First FROM WordList:Word GROUP BY LanguageId

• Group By
• Aggregate Functions