Add rownumber to select-result


how can I add a rownumber to a select result (like rank over in MSSQL). I have a leaderboard-table, want to sort by score and add a rank-number to each entry.



You’ll either need to use a Custom SQL or potentially a Custom Select to execute the Custom Query.

In general you’d select into a typed Custom POCO that matches the result set the custom query returns or you could use a Dynamic Result Set.

alright, I’ll try that, thanks