select distinct latest in a group postgres code example Example: psql select unique SELECT DISTINCT column1 FROM table_name;