I know this has been discussed MANY MANY times, but I've used all the previous answers and still have issues.
In my table we have to look for top 3 in each group and show ties. So if there is a tie it should return more than 3 rows.
I have a working MS Access query, but MySQL doesn't use TOP and LIMIT can't be used with IN... So now I have to start all over.
Further, If this proves to be to difficult, I can use 2 queries: first report ties (in top 3 of each group) and fix them (ties will not be allowed - this is a contest with only 3 winners and we will need to break ties) and second, display results...