zackcez Posted June 4, 2009 Share Posted June 4, 2009 I'm just wondering how I can order by two fields Explain: I'm ordering by Level, there's two rows with the same 'Level', then if that happens I want it to order by 'exp'...Example: Bob - Level: 1234 Exp: 432 Sue - Level: 1234 Exp: 1234 Tim - Level: 12 Exp: 5000 I would like it to have Sue ahead, then Bob, then Tim. So basically I want it to first order by "level" if there's more than one row with the same thing, then order those by 'exp' All help is appreciated, Zack Quote Link to comment Share on other sites More sharing options...
Ken2k7 Posted June 4, 2009 Share Posted June 4, 2009 ORDER BY Level DESC, Exp ASC Like that? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.