sastro Posted August 3, 2009 Share Posted August 3, 2009 hi, my table is like this : name ==== recall accord carolina football carolina football airbag accord civic recalls deangelo carolina football williams accord panthers fantasy carolina football fantasy fantasy rushing baton rouge office wednesday missing fantasy hormone How to SELECT order by most record DESC, so the result is like this carolina accord football fantasy airbag baton . . . Carolilina is on the top because it 4 times in record, accord 3 times.. etc.. Thanks in advanced Link to comment https://forums.phpfreaks.com/topic/168663-solved-select-option/ Share on other sites More sharing options...
kickstart Posted August 3, 2009 Share Posted August 3, 2009 Hi Like this:- SELECT Name, COUNT(*) AS NameCount FROM NameTable GROUP BY Name ORDER BY NameCount DESC (assuming the table is called NameTable). All the best Keith Link to comment https://forums.phpfreaks.com/topic/168663-solved-select-option/#findComment-889736 Share on other sites More sharing options...
sastro Posted August 3, 2009 Author Share Posted August 3, 2009 Thanks kickstart. Its works... Link to comment https://forums.phpfreaks.com/topic/168663-solved-select-option/#findComment-889751 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.