PostgreSQL: Documentation: 14: SELECT

PHOTO EMBED

Mon Oct 18 2021 02:26:14 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira

SELECT DISTINCT ON (location) location, time, report
    FROM weather_reports
    ORDER BY location, time DESC;
content_copyCOPY

https://www.postgresql.org/docs/current/sql-select.html