List:General Discussion« Previous MessageNext Message »
From:Ed Lazor Date:December 23 2004 8:33pm
Subject:RE: Query question
View as plain text  
Thanks, Shawn.  I didn't think count would just limit to the items being
grouped - very handy =) 

-Ed

> SELECT URL, count(1) as popularity
> FROM yourtablename
> GROUP BY URL
> ORDER BY popularity DESC
> LIMIT 50;

Thread
Query questionEd Lazor23 Dec
Re: Query questionSGreen23 Dec
  • RE: Query questionEd Lazor23 Dec
RE: Query questionDimitar Georgievski23 Dec