I am trying to display a top 3 ranking in a canvas. For this I need the highest score, the middle score and the lowest score.
The highest score is correctly queried but I am not able to determine the 2nd score.
Can you help me here?
This is the query I use to get the data:
WHERE "data.type" = 'end'
GROUP BY id, score
ORDER BY score DESC
Many thanks in advance!