I have a table something like the below. I would like to create a select that will retrieve the TOP 2 records for each category? I can't seem to get my head around this one, is it really that difficult?
Desired Results: TYPE NAME VIEWS Campground X 4 Campground Bar 3 Trail Here 3 Trail There 3 Lake Med 3 Lake Small 2 >From Table: TYPE NAME VIEWS Campground Foo 2 Campground Bar 3 Campground X 4 Campground Y 3 Trail Joe's 1 Trail Pac 2 Trail Here 3 Trail There 3 Lake Big 1 Lake Small 2 Lake Med 3 _____ I've stopped 18,045 spam messages. You can too! One month FREE spam protection at http://www.cloudmark.com/spamnetsig/} ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
