Short question:
How do I get the row number as an extra column in grails criteria?
I could only find rowCount which is not what I need
Asked
Active
Viewed 185 times
0
-
Can you elaborate more on what do you want to achieve? – Sandeep Poonia Aug 19 '15 at 10:27
-
Sure. I want a row Number (which is basically the number in the leaderboard because I sort on a specific value). I do this because I want the rank of a specific User in the board – Bernhard Aug 19 '15 at 12:50
-
ask yourself: how would you do it in a good'ol SQL query? – injecteer Aug 20 '15 at 14:42
-
I would do this: SELECT id, ROW_NUMBER(), FROM user – Bernhard Aug 28 '15 at 14:38
