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? 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 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
Archived
This topic is now archived and is closed to further replies.