Distinct Clause

DISTINCT clause is used to remove duplicates from the result set of a SELECT statement. select payment_method from orders select distinct(payment_method) from orders