To remove duplicate rows from the result of a query, specify the SQL qualifier DISTINCT in select list.