Say I have a table that contains a list of product groups (Alpha, Bravo, Charlie), individual products within each group (A01, A02 etc. B01, B02 etc.) and the price of each product.
What I need is to output the 3 highest value products within every product group, so the output would look something like this:
GROUP PRODUCT PRICE Alpha A03 2617 Alpha A07 2309 Alpha A02 1926 Bravo B04 983 Bravo B05 983 Bravo B02 872 Charlie C02 3615 Charlie C07 1762 Charlie C01 760