I have a table with the following columns:
PRODUCT_ID | PRODUCT_NAME | GROUP_ID | GROUP_NAME | PRICE
GROUP_NAME are not UNIQUE. Can I make a selection which just returns each
GROUP_ID with its
GROUP_NAME and its
Or will I have to make a SELECT query for each GROUP?
For example: I have 12000 PRODUCTs which are in 14 GROUPs. My query should then only return 14 rows.