|< < 45 > >|

Subqueries

The in operator tests membership in a set

Running the complete query

Data

The topmost query selects for authors whose author_id is in {10001, 10003}.

select name from author where author_id in ( select author_id from book where year between 1960 and 1969 )

name Kurt Vonnegut Jr.

|< < 45 > >|