ranking or incrementing results
Posted: Thu Feb 17, 2005 1:52 pm
What I am trying to do here is to rank the results I am getting based on one column, but order them based on another column.
For instance, say I've got a table locations. I want to query it such that I get a rank based on the score, but I want it ordered by the location name. Is this even possible?
I am using MySQL
For instance, say I've got a table locations. I want to query it such that I get a rank based on the score, but I want it ordered by the location name. Is this even possible?
I am using MySQL