I need some help with a SQL Query on my SQL2000 database. I'm stumped as to how I can achieve this .....
I have a radio station playlist and the table (tblPlaylist) has the following fields: Sequence (int), (which is the primary key) shownumber (int), SongID (int) As each song is programmed it's entered in the database as songid, shownumber and is given a sequence. The songs are then played in sequence order. And I want to know which songs were played most over the last 4 weeks. A sort of top ten if you like. How can I do a query on this table which will give me a result like this: Songid count (i.e. times played in the last 4 weeks) 657 15 4325 12 551 11 5789 10 etc. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
