Esta página aún no está disponible en su idioma local. Estamos trabajando arduamente para agregar más versiones de idiomas. Gracias por tu apoyo.

On this page

Show all

Subqueries

Updated on 2022-11-18 GMT+08:00

EXISTS

The EXISTS predicate determines whether to return any row.

SELECT name FROM nation WHERE EXISTS (SELECT * FROM region WHERE region.regionkey = nation.regionkey)

IN

It determines whether any value generated by a subquery is equal to a given expression. The IN result complies with the standard null rule. Only one column must be generated for a subquery.

SELECT name FROM nation WHERE regionkey IN (SELECT regionkey FROM region)
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback