# mySQL get the rank of a query result

**URL:** <https://forum.kirupa.com/t/mysql-get-the-rank-of-a-query-result/194091>\
**Category:** programming\
**Created:** [July 20, 2006, 1:35pm UTC](https://forum.kirupa.com/t/mysql-get-the-rank-of-a-query-result/194091 "2006-07-20T13:35:41Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![StarXploser](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/starxploser/32/875_2.png) [@StarXploser](https://forum.kirupa.com/u/StarXploser)\
**Post date:** [July 20, 2006, 1:35pm UTC](https://forum.kirupa.com/t/mysql-get-the-rank-of-a-query-result/194091/1 "2006-07-20T13:35:41Z")

</div>

hello,  
I’m trying to fetch the score of a user. display his rank according to his points. and display the user with rank+1 and his score.

what’s the best way to do this?

I’ve been looking online, apparently there’s something callled RANK() in mySQL but i can’t find the documentation…

any help would be appreciated, thx