Quantified Comparison Predicates – Some of SQL’s Rarest Species

A recent Tweet by Aaron Bertrand (whom you've certainly encountered on Stack Overflow) has triggered my interest https://twitter.com/AaronBertrand/status/752537591392657408 Indeed, few people I've met and who've visited my SQL masterclass have heard about the ANY and ALL quantifiers, which you can use in SQL, let alone used them on a regular basis (or ever used them … Continue reading Quantified Comparison Predicates – Some of SQL’s Rarest Species

A Wonderful SQL Feature: Quantified Comparison Predicates (ANY, ALL)

Have you ever wondered about the use-case behind SQL's ANY (also: SOME) and ALL keywords? You have probably not yet encountered these keywords in the wild. Yet they can be extremely useful. But first, let's see how they're defined in the SQL standard. The easy part: 8.7 <quantified comparison predicate> Function Specify a quantified comparison. … Continue reading A Wonderful SQL Feature: Quantified Comparison Predicates (ANY, ALL)