ORDER BY

SELECT * 
FROM SchemaName.TableName
ORDER BY GroupName -- ASC or DESC

SELECT * 
FROM SchemaName.TableName
ORDER BY GroupName DESC, Name -- order by group, and then name