SQL -- Selecting Distinct

The following example displays a listing of each of the unique (distinct) items from the items_ordered table.

 

Select the distinct items in the items_ordered table. In other words, display a listing of each of the unique items from the items_ordered table.

SELECT DISTINCT item

FROM items_ordered;