How to sort result of each grouped field

What I’m trying to do

I want to sort the result of each grouped field
Here I want to sort “Variant” such as Hemoglobin A1, Fetal Hemoglobin, Hemoglobin A2 alphabetically

Things I have tried

I have tried this but it sorts the rows and not the individual results of the rows

TABLE rows.concentration as "Concentration", rows.file.link as "Variant"
FROM #Hemoglobin/hb/variants 
GROUP BY stage-of-life as "Stage of Life"
SORT stage-of-life asc
SORT rows.file.link asc

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.