postgresql apply distinct among one of the column in SELECT

Question

SELECT DISTINCT COL_A, COL_B, COL_C, COL_D, from Table_E

If I want to only consider COL_A's duplication, how to use DISTINCT properly only for the COL_A?

Erwin Brandstetter · Accepted Answer · 2020-04-15 17:00:15Z

1

Use DISTINCT ON:

SELECT DISTINCT ON (COL_A) COL_A, COL_B, COL_C, COL_D FROM Table_E;

See:

answered Apr 15, 2020 at 17:00

669k160 gold badges1.2k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1