↓ Skip to main content
Vonng
Background Image

SQL

Implementing Mutual Exclusion Constraints with Exclude
·854 words·5 mins
PostgreSQL PG Development SQL
Exclude constraint is a PostgreSQL extension that can implement more advanced and sophisticated database constraints.
Distinct On: Remove Duplicate Data
·557 words·3 mins
PostgreSQL PG Development SQL
Use Distinct On extension clause to quickly find records with maximum/minimum values within groups