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-012017-01-012017-10-152017-10-152017-10-152017-11-092017-11-092017-11-092017-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-092017-11-092017-11-092017-11-09
(4 rows)
Regards
Lutz