i'm feeling brain dead today and cant seem to work this out. i ashamed as it seems to be such a basic problem. I have an sql query: select "distinct item1, item2..." and want to find the number of ...

I have a table that logs a record containing a userid, a fileid and a date, one record inserted every time that file is downloaded.<BR><BR>I want to get the top 10 downloads by count for a given date ...