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 Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
sastro Posted August 3, 2009 Author Share Posted August 3, 2009 Thanks kickstart. Its works... 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.