某个表按某个列分组且按另一个列排序

SELECT *,ROW_NUMBER() OVER(PARTITION BY bc ORDER BY CONVERT(int,firstOrder) ASC) AS num
FROM #temp