Hello, everyone!
I'm facing a problem that I think it's easy to solute, but I'm not able to think how can I do that.
I have this database with many repeated values because I need it for identification. And I want to count the number of items, but just once.
For example:
| IdProd | Product | Brand | IdMat | Material |
| 1 | iPhone 13 | Apple | 45 | Chipset |
| 1 | iPhone 13 | Apple | 46 | Camera |
| 1 | iPhone 13 | Apple | 87 | Glass |
| 1 | iPhone 13 | Apple | 36 | Screen |
| 2 | Galaxy S22 | Samsung | 45 | Chipset |
| 2 | Galaxy S22 | Samsung | 46 | Camera |
| 2 | Galaxy S22 | Samsung | 87 | Glass |
| 2 | Galaxy S22 | Samsung | 36 | Screen |
| 3 | iPad | Apple | 45 | Chipset |
| 3 | iPad | Apple | 46 | Camera |
| 3 | iPad | Apple | 87 | Glass |
| 3 | iPad | Apple | 36 | Screen |
So I want to count how many times Apple appears in my table, but just once. In that case, it would be only two times.
