Answer to Question #3637 in Databases | SQL | Oracle | MS Access for Thomas
I want to create a leaderboard from this information, I've had a look through some leaderboard threads/questions and they all seem to be created from already summed values (eg. Each user would already have their kills totaled) and that's fine but my dataset won't be that big for a while so I'm happy to calculate it on the fly.
Also there are records in the kills table that need to be excluded such as kills by environment and such but I believe that can be easily handled with a:
WHERE killed='playerType' AND killed_by NOT IN (<list of environment IDs>)
So basically I need to sum each separate user ID (which I'm not sure how to do) then order,limit and display them (which I'm fine with).
Note: There is no total of kills for each user, each kill is a separate entry in the kills table.
Need a fast expert's response?Submit order
and get a quick answer at the best price
for any assignment or question with DETAILED EXPLANATIONS!