Hello,
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.
cheers
Michael
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