ShadowMetis Posted June 22, 2006 Share Posted June 22, 2006 Is there a way within MySQL to order the selected rows by one column, then by a second column if two rows have the same value for the first colum?For Example:[code]| foo | bar ||=====|=====|| 4 | 2 || 6 | 6 || 3 | 3 || 7 | 0 || 8 | 9 || 6 | 1 || 2 | 5 |[/code]If I wanted those ordered by foo, since foo has the same value for the second and sixth row, I'd want it to know to put the second row first because the bar value is higher than that of the sixth. Is this possible and what is the syntax? Quote Link to comment https://forums.phpfreaks.com/topic/12613-simple-mysql-question-about-a-select-query/ Share on other sites More sharing options...
.josh Posted June 22, 2006 Share Posted June 22, 2006 select * from table order by foo, bar desc Quote Link to comment https://forums.phpfreaks.com/topic/12613-simple-mysql-question-about-a-select-query/#findComment-48365 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.