select statement without including duplicate data

select statement without including duplicate data References I am trying to select from a database but because the database as duplicate data and the item names in each data may or may not be duplicated. Please look at the example below to understand more Table shoe shoeid pid Name 1 1 green 2 1 green 3 2 red 4 3 red Thats a simple example. How I can I select Name and pid from this table but i dont want to see any repeated numbers or names. for example i don\'t want to see red or green or whatever color i have in the database more than once. Please remember I have over 100 colors in the database. The same thing apply to the pid