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/
Created
August 3, 2021 15:34
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment