My database exemple:
| NAME | EMAIL | REGION | CITY | IDNUMBER |
| A | firstname.lastname@example.org | RegionA | X | 123 |
| A | email@example.com | RegionA | X | 123 |
| A | firstname.lastname@example.org | RegionA | X | 123 |
| B | email@example.com | RegionA | Y | 321 |
| B | firstname.lastname@example.org | RegionA | Y | 321 |
| C | email@example.com | RegionA | X | 456 |
| D | firstname.lastname@example.org | Region B | B | 890 |
And i Need this table as result:
| NAME | REGION | CITY |
| A | RegionA | X |
| B | RegionA | Y |
| C | RegionA | X |
but I have some duplicate rows in my database (ex.: some rows have the same name, but with diferent email in each row). The table is showing the duplicate rows, but i need to show these items just one time (not duplicated, as the exemple above).
Sorry for my english. But thanks for the help.