Re: Please advice on a query

Hi,

Am 14.11.17 um 18:19 schrieb Efraín Déctor:
> You could use a window function:
> https://www.postgresql.org/docs/current/static/functions-window.html

Like this:

lutz=> \d dates
Table "pg_temp_3.dates"
Column | Type | Modifiers
--------+------+-----------
d | date |

lutz=> select * from dates;
d
------------
2017-01-01
2017-01-01
2017-10-15
2017-10-15
2017-10-15
2017-11-09
2017-11-09
2017-11-09
2017-11-09
(9 rows)

lutz=> select d from (
select d, rank() over (order by d desc) as r from dates
) as sq
where r = 1;
d
------------
2017-11-09
2017-11-09
2017-11-09
2017-11-09
(4 rows)

Regards

Lutz