How to select product that have the maximum price of each category?
- by kimleng
The below is my table that has the item such as:
ProductId ProductName Category Price
1 Tiger Beer $12.00
2 ABC Beer $13.99
3 Anchor Beer $9.00
4 Apolo Wine $10.88
5 Randonal Wine …
