semi-complex sql problem
Posted: Sun Aug 13, 2006 2:38 pm
Or it could be really easy...dunno..
Either way,
I have a database with product ID's. I want to select the most commonly x occuring instances of a paticular ID. where x is say, the top 10 most occuring and then in another table i have the the product cost and I only need to select the most commonly occuring under a certian price. how would I do this with sql? it seems like something there'd be a built in function for. any ideas?
Either way,
I have a database with product ID's. I want to select the most commonly x occuring instances of a paticular ID. where x is say, the top 10 most occuring and then in another table i have the the product cost and I only need to select the most commonly occuring under a certian price. how would I do this with sql? it seems like something there'd be a built in function for. any ideas?