Remind your code! Answer your questions!
SELECT ID, groupName, hitValue, Rank() OVER (PARTITION BY groupName ORDER BY hitValueDESC) AS Rank FROM myHits