Contents

Using SELECT in SELECT

The result of a SELECT statement may be used as a value in
another statement. For example the statement
SELECT continent FROM world WHERE name = 'Brazil'
evaluates to 'South America' so we can use this value to
obtain a list of all countries in the same continent as
'Brazil'