CREATE TABLE #table1(col1 nvarchar(1), col2 int, OrderMe int);

INSERT INTO #table1 VALUES('B','100',0);

INSERT INTO #table1 VALUES('A','200',1);

INSERT INTO #table1 VALUES('B','300',0);

INSERT INTO #table1 VALUES('C','400',1);

WITH CTE (col1,col2, OrderMe) as (

SELECT col1, SUM(col2), OrderMe

FROM #table1

GROUP BY col1, OrderMe

)

SELECT col1,Col2 FROM cte

ORDER BY OrderMe

Group by isnt' an ordering function, and if you want a specific order on your table, its best to add an ordering key of some kind.