Php+mysql Statistics Ranking

Integrating system is being developed! One of the data is to show the user points ranking?
I can't think of such a good way!

The simplest scenario is to unify the ranking of a field's points data? such as the integral field, the integer stored inside!

How to rank? Or how to get his sequence rank in the sort?

Select COUNT (*) + 1 as rank from ' users ' where number > (select ' Number ' from ' Users ' where openid= ' otf-gjrf-nt1cf2w8m Hrppz2arvq ')

Count The number of the first Select Count (*+1 from 'tablewhere> (Select  from 'tablewhere=*)

Select Count (1fromwhere points total >or (total number of points = and user number <=  Zhang San user number) This is also equivalent to orderbydescASC

Php+mysql Statistics Ranking