I need help with a select query. I have a database of products.
Each product has a category, and a sold field. There are say.. 10 products per category. I need a sql statement that will give me a set of random unique products, 1 from each category, and order it by the count sold. Can this be done? Thanks for your help.
