Use Distinct On extension clause to quickly find records with maximum/minimum values within groups Read more