Hi,
I have a table containing the scores of my game
CREATE TABLE Scores
(
PlayerName varchar(50),
LevelId integer,
Score integer,
Difficulty integer
);
and I would like to always limit the number of score entries to 10 elements (for a specific level, and difficulty)
So when the score table has 10 entries (for a specific level, and difficulty) and the player has a new highscore, I would like to delete the last element (the lowest score), and insert the new highscore. How can I do this?
Thanks for help