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?

score 1 · Accepted Answer · answered Apr 15 '20 at 17:00

1

Use DISTINCT ON:

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

See:

answered Apr 15 '20 at 17:00

1 Answers1