CREATE Table #Temp
( vote int,imagename varchar(20),weekid int)
INSERT INTO #Temp
SELECT 4,'a',1
UNION
SELECT 3,'b',1
UNION
SElect 1,'c',1
UNION
Select 1,'d',1
UNION
SElect 2,'c',2
UNION
Select 3,'d',2
SELECT T.* FROM #Temp T
INNER JOIN (SELECT max(vote) as vote, weekid FROM #Temp GROUP BY weekid) SQ ON SQ.weekid = T.Weekid AND SQ.vote = T.Vote
ORDER BY weekid
Drop TABLE #Temp