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 ...

This article is also available as a PDF download. Arranging data in a manner that’s meaningful can be a challenge. Sometimes all you need is a simple sort. Often, you need more–you need groups you can ...