Sep 9, 2019 in Spark Sql
Q:

SQL EXISTS Operator

1 Answer

0 votes
Sep 9, 2019

The SQL EXISTS Operator

The EXISTS operator is used to test for the existence of any record in a subquery.

The EXISTS operator returns true if the subquery returns one or more records.

EXISTS Syntax

SELECT column_name(s)
FROM table_name
WHERE EXISTS
(SELECT column_name FROM table_name WHERE condition);

Related questions

0 votes
Sep 9, 2019 in Spark Sql
0 votes
Sep 9, 2019 in Spark Sql
...