top 10

[teiben]

I'm trying to create a query, (looked at Northwinds query top 10 most expensive and I don't get it) that will sort through thousands of records and tell me what the top 10 rejected parts are. I'm guessing for starters a cross tab, which I think would summarize and then some how extract the 10 most frequently rejected parts.

Are there any examples anywhere with an example of how to do this?

 

[grnzbra]

Sort on price decending and select top 10. Of course, if you have 2 or more with the same price, each of those will be counted as one of the ten. In that case, you'd need to select only the price as a select distinct query, sort decending and select the top ten. Then you'd have to link it back on price with an inner join in order to get all of the items in the top ten price list.