XpertWorlock Posted July 12, 2008 Share Posted July 12, 2008 Is it possible two sorts by two rows in a database I.e. Sort by one row (integer) and than another row (integer). 0/0, 0/1, 0/2, 0/3, 0/4, 1/0, 1/1, 1/2, 2/0, 2/1, etc. I've tried various methods and am trying to do it with as little code as possible Thanks alot Mike Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted July 12, 2008 Share Posted July 12, 2008 I think you might be asking about sorting by two columns? If so, you need an ORDER BY term in the query that lists the columns - ORDER BY column1, column2 This will sort using column1 values, then within each value in column1, it will sort using the column2 values. Quote Link to comment Share on other sites More sharing options...
XpertWorlock Posted July 12, 2008 Author Share Posted July 12, 2008 excellent that's exactly what I needed to know Yeah I worded it incorrectly Thanks greatly Topic Solved 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.