SELECT DISTINCT colA, colB, colC picks only one row per distinct combination of all columns colA and colB and colC, dropping the duplicates.
Source: https://chartscreator.com/blog/postgresql-distinct-on-multiple-columns/
SELECT DISTINCT colA, colB, colC picks only one row per distinct combination of all columns colA and colB and colC, dropping the duplicates.
Source: https://chartscreator.com/blog/postgresql-distinct-on-multiple-columns/