Unanswered: need some complicated query
Looking for solution to following problem which looks quite easy drom the first sight but not not that one when I looked deeper into it .... :
Have a table ""results" where following fields present:
(it's for some online gaming purposes)
And I need to get the recordset:
Where score is the SUM of 5 maximum results in results.points.
Any idea or maybe just a point of view in which direction to dig? Because as for now I don't see any other solution except to launching separate query for on "resutls" table for every user and then building needed recordset from that data ...