At 10:19 -0600 2/1/02, Paul DuBois wrote: >At 15:56 +0000 2/1/02, SED wrote: >>Hi, >> >>I'm trying to make a query where I select something distinct ordered by >>most frequent? >> >>I found below example from the manual but I can not figure out how I >>should order them by most frequent - do you know how? >> >> SELECT DISTINCT owner FROM pet > >Don't use distinct in that case. Count them and order by the descending >counts. > >SELECT owner, COUNT(owner) AS frequency FROM pet ORDER BY frequency DESC;
Oops. Forgot the GROUP BY: SELECT owner, COUNT(owner) AS frequency FROM pet GROUP BY owner, ORDER BY frequency DESC; > >> >>Regards, >>SED --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php