An easy little query for someone - I appear to be having brain freeze over it (think it's because it's a Friday...)
I want to be able to show the daily top 20 pages from a table. If I run the following query, I only get the top 20 from the first date stored in the table - how would I show the top 20 pages from each date stored in the table?
SELECT TOP 20 * FROM Table
ORDER BY Date, Count DESC
Thanks
I want to be able to show the daily top 20 pages from a table. If I run the following query, I only get the top 20 from the first date stored in the table - how would I show the top 20 pages from each date stored in the table?
SELECT TOP 20 * FROM Table
ORDER BY Date, Count DESC
Thanks