Sorting SQL table results

Question

Name      Rank    XP
-----------------------
Craig     0       100
Morris    1       0
Roger     0       4000

I want my SQL statement to pull names from the above table in the order that the RANK field takes priority, followed by the XP field.

So the correct order would be;

Morris
Roger
Craig

I've tried a 'ORDER BY Rank ASC, XP DESC' but can't seem to get it to work.

Any tips?

what do you mean, "but can't seem to get it to work" ? Show the query and the error message you are getting, please. — BWS
– BWS, Commented Dec 11, 2013 at 20:52
Maybe you need ORDER BY Rank DESC, XP DESC? I agree that we need to see entire query and output. — Matt Runion
– Matt Runion, Commented Dec 11, 2013 at 20:54

Steven Wexler · Accepted Answer · 2013-12-11 20:59:54Z

3

ORDER BY [Rank] DESC, XP DESC

will produce

Morris
Roger
Craig

ORDER BY [Rank] ASC, XP DESC

will produce

Roger
Craig
Morris

answered Dec 11, 2013 at 20:53

Steven Wexler

17.5k8 gold badges59 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

I think the key distinction is that he should be ordering by rank descending instead of ascending.

BWS · Accepted Answer · 2013-12-11 20:53:56Z

0

"RANK" is an SQL reserved word. Try this:

ORDER BY [RANK] DESC, XP DESC

answered Dec 11, 2013 at 20:53

BWS

3,85620 silver badges26 bronze badges