MySQL ranking query
$10-30 USD
Pagado a la entrega
Hello,
I am looking for someone that can create me a query to get a ranking from a database table on basis of points.
For the context, I am making an app that contains ranking and on a page I want to display the ranking position of the user among other users.
For example user is nr 67 on the list of people with the most points, I want to get people ranked from 50 until 99.
If the person is ranked 521 I want to get 500 until 549.
So the query result are within following pattern:
1....49
50...99
100...149
....
So simply said I want to get the surrounding 50 people in the ranking.
My Mysql database table looks like the following:
#############
# Users #
#############
# ID #
# username #
# xp # (points)
#############
The database version I am running is 5.5.40, so the query should be compatible with this version.
Nº del proyecto: #7577965
Sobre el proyecto
Adjudicado a:
Wed, 29 Apr 2015 20:58:30 +0000 Database: Tanking basis: Anything besides Points? More than 2 persons with equal no of points get same ranking? Count of persons? Query alone or as part of a shell script?
19 freelancers están ofertando un promedio de $23 por este trabajo
I am 8+ Years of Experienced Software Developer. ASP .Net , C# , VB .Net , Visual Basic, Excel VBA , MS SQL Server , MYSQL , Oracle , MS Access, Crystal Report, Telerik , Bootstrap , HTML 5 , CSS , Java Script are my Más
Hello, I have been working with a MNC bases company since last ~ 4 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in Más
Hi, I have been working on mysql + Php development for 4+ years. I have worked on multiple projects. I have done work very similar to your like in one of my project I had to retrieve around 10-15 commodities which a Más
I have 5 years of programming experience. I can help you solve this problem. When you work with me you will feel very comfortable.
I will create a MySQL query on a table containing users and points. The query will return users ranked 1....49 50...99 100...149 etc.
Hi, I think I could help you very fast. If I understood correctly you are going to be sending the userId and you need to get the 50 people in the ranking around this person (rounding to 50s). Is that right? Con Más
My solutions .................................................................................................................................................................
I have more than 5 years experience as a Senior Web Developer. During my job I have done 260+ projects for Indian & USA clients. My dedication boosts me to deliver projects on time. Please give me an opportunity to wor Más
MySQL ranking query Hello, I am looking for someone that can create me a query to get a ranking from a database table on basis of points.... ---> The work is quite easy for me, I can help you. Thank!
É o meu primeiro trabalho aqui no freelancer. Vou dar o meu melhor para sua solução e entregar no prazo previsto.