176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

MySQL query to rank players
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Dec 10, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Mon, Dec 10, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

I want a query to rank the players in a table based on score (including tied ranks, tie breaker can be decided by username) and another query given a player name to return the two players above and below the given user with everyone's ranks (including the player in which the query is based).

I've attached an excel document with an example scenario and the required results.

Thanks
------------------------------------------
Added 10 DEC 2012, 21:00 PM EST
Sorry just attached example now

Sign in or Register to see more

Desired Skills
MySQL Administration, SQL
Job ID: 35920178
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

Victor I.      
Victor I.'s identity has been verified.  Learn More
 United States  |  
Database developer that delivers superior code with outstanding speed of execution
8
  |  
 4.9   |  Private   |  15 Jobs
Bid ID: 35920480  |  Submitted: Dec 10, 2012 20:47 ET 
Proposal SEALED

 United States  |  
Expert programmer and web developer specializing in PHP, C#, SQL, LAMP and general web development.
1
  |  
 5.0   |  Private   |  102 Jobs
Bid ID: 35920387  |  Submitted: Dec 10, 2012 20:42 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »