dcsimg
www.webdeveloper.com
Results 1 to 2 of 2

Thread: Ranking query help

  1. #1
    Join Date
    May 2011
    Posts
    1

    Ranking query help

    I'm stuck on a site I'm building, I need to make a ranking page that shows results from contests and sorts them by points and gives them a ranking 1 to however may people competed. I have the basics done, I can get the info in the DB and display it on the page but as for the sql query I need to sort the results I'm stumped. It would end up like this:

    Rank Rider Total Points Comp1 Comp2
    1 John 1000 500 500
    2 Fred 800 400 400

    So it would add all the comp columns give a total and then rank based on the highest points
    Here is an example of what I need to do.

    http://www.worldrollingseries.com/rankings.html

    Thank you for any help you can provide...I've googled my self to death looking for tuts on the subject.

  2. #2
    Join Date
    Dec 2002
    Location
    St. Louis, MO, USA
    Posts
    1,582
    I don't think you can sort by an alias (the sum of Comp1 and Comp2), so you'd most likely have to create a temp table, insert the data into there (including the calculation) and select from that, sorting by the column created for the sum, descending.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles