Leaderboard in App

Help me for making Leaderboard using mysql in kodular. Here is sql

How convert it to kodular blocks please…

SELECT @rank:= @rank + 1 as rank, s.* FROM ( SELECT field1, field2, … FROM players, (SELECT @rank:=0) r ORDER BY score DESC LIMIT 25 ) s

1 Like

this amazing Tutorial on Mysql by @Taifun will help you to learn.


1 Like

a simple

SELECT player, score FROM players ORDER BY score DESC LIMIT 25

will do it
you might want to learn how to work with lists to be able to process the result


This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.