T-SQL select into temp table does not have correct result

Question

-- This Result Is Right and work correctly:

SELECT AutoId, Name,[Group],[Priority], SUMCalculatedPercent
FROM
(SELECT DISTINCT *,
 ROW_NUMBER() OVER 
 (
    PARTITION BY [Group] ORDER BY SUMCalculatedPercent DESC,[Priority]
 ) 
 AS ranker 
 FROM #GroupMasterNameChoose
)Z
WHERE ranker = 1
ORDER BY Z.SUMCalculatedPercent DESC,Z.[Priority]

---

-- This Result Is Wrong :

SELECT AutoId, Name,[Group],[Priority], SUMCalculatedPercent
INTO #GroupOwner
FROM
(SELECT DISTINCT *,
 ROW_NUMBER() OVER 
 (
    PARTITION BY [Group] ORDER BY SUMCalculatedPercent DESC,[Priority]
 ) 
 AS ranker 
 FROM #GroupMasterNameChoose
)Z
WHERE ranker = 1
ORDER BY Z.SUMCalculatedPercent DESC,Z.[Priority]

-- Problem : I Need Store My Right Result To Temp Table

Answer 1

Remove ORDER BY Z.SUMCalculatedPercent DESC,Z.[Priority]