Quick answer: The SQL DISTINCT keyword removes duplicate rows from a query result based on the selected expressions. For example, SELECT DISTINCT department FROM employees; returns each department value once. DISTINCT does not delete duplicate records from the underlying table. While working with huge data there may be a situation when you have multiple duplicate records in a table. While fetching such records, you want to fetch only unique/distinct records instead of… Read More »SQL DISTINCT in PostgreSQL: Remove Duplicate Results with Examples