DevOps Articles

SQL DISTINCT Is Not a Function

Let's see where people go wrong when using the DISTINCT keyword in SQL, how you should be using it, and some tips for PostgreSQL users. A very common misconception I often encounter with SQL users is the idea that DISTINCT is something like a function, and that it can take parenthesised arguments.