How do I find the unique column value with maximum date consideration in PostgreSQL?

Question

For Example

I need a unique product_id with a maximum date. Required value like below

product_id	costhead_id	date
1020209	1000183	2021-12-19 16:19:55
1020210	1000183	2021-12-20 16:19:55

The question seems to be a duplicate of this: https://stackoverflow.com/questions/16914098/how-to-select-id-with-max-date-group-by-category-in-postgresql — kunsterD93, Feb 23 '22 at 13:05

score 1 · Accepted Answer · answered Feb 23 '22 at 11:57

1

You can use distinct on:

select distinct on(product_id) *
from table_name
order by product_id, date desc

answered Feb 23 '22 at 11:57

Zakaria

1 Answers1