DISTINCT ON

In PostgreSQL, the DISTINCT ON clause is a powerful tool used in the SELECT statement to retrieve unique rows based on a specified set of columns. It is often combined with the ORDER BY clause to determine which unique rows to select.