select top 5 count(ProductID) as topfiveproducts, productID from orders order by topfiveproducts desc ( <-- I don't remember if you can sort on an alias created from aggregate function )
I also don't think that you would need a distinct clause. At 12:02 PM 11/28/2001 +0800, you wrote: >Hi all, > >This is probably really simple, but I just can't seem to get it! > >To simplify, I have an orders table, with a primary key "OrderID", and a >foreign key "ProductID". I want to get the top five most ordered >products. I thought maybe using a COUNT with DISTINCT, and restricting >the rows returned, but how do I ORDER BY? > >Any help on how to approach this will be greatly appreciated. > >Thanks, >K. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
