on suiteanswers it said the

when order by setting is similar to oracle's keep dense_rank function

so I messed with that until it worked