Ian Skinner wrote: > 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
So which results do you want if there are 3 names with the same number of views? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
