Loading and Filtering table column (100+ items)

Good Day,

I have a table with many columns and rows. I would like to retrieve only one column of the database and filter out all duplicate rows. There is also more than a 100 rows of data, so I am not sure how the logic will look for this so I can display the list on my page.

Kind Regards
Donovan