Portal Home > Knowledgebase > Articles Database > Simple question regarding sorting SQL Result
Posted by latheesan, 06-28-2008, 11:09 AM Hello, I have a "ladder" table like this: http://img105.imageshack.us/img105/5674/63402805nq9.png I want to do a select * query on it but sort the results in the following way: completed_in ASC party_size ASC total_kills DESC So, in psuedo code, the party that stays on top of the ladder is worked out by, who ever completed an event in lowest time with the smallest party size with the most kills How can I go about doing this?
Posted by greg2007, 06-28-2008, 02:26 PM Fairly straight forward... SELECT * FROM table ORDER BY completed_in ASC, party_size ASC, total_kills DESC
Add to Favourites Print this Article