Top 3 issue

[Chimp8471]

trying to run a query that highlights the top 3 problems on a specific line by week number.

i have the sql to sort it by top 3 but the trouble i have is, that it only then shows me the top 3 events for 3 weeks.

i want to show the top 3 problems for each week.

current sql is :


SELECT TOP 3 top3_byTime.EventCode, top3_byTime.CodeDescription, top3_byTime.total, top3_byTime.Occur, top3_byTime.Line, top3_byTime.WeekNumber
FROM top3_byTime
ORDER BY top3_byTime.total DESC;



please help