O'Reilly logo

Joe Celko's SQL for Smarties, 5th Edition by Joe Celko

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 18

Subquery Predicates

Abstract

Most programming languages use simple scalar predicates with theta operators. They apply to a single scalar value. SQL also has them, but it also has set-oriented predicates. Since SQL is a set-oriented language this is should not be a surprise. These predicates apply to subsets that are built with subqueries.

Keywords

UNIQUE()

[NOT] EXISTS

[NOT] IN()

< theta > ANY < subquery >

< theta > ALL < subquery >

Most programming languages use simple scalar predicates with theta operators. They apply to a single scalar value. SQL also has them, but it also has set-oriented predicates. Since SQL is a set-oriented language this is should not be a surprise. These predicates apply to subsets that are built with ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required