Published Feb 16, 2022Updated Aug 18, 2022
Contribute to Docs
EXISTS operator tests a subquery and returns
TRUE if at least one record satisfies it. Otherwise,
FALSE is returned.
SELECT column1, column2, ... FROM table_one WHERE EXISTS (SELECT column1 FROM table_two WHERE condition);
In the example below, the statement returns
TRUE for each row in the
users table that has a corresponding
user_id value in the
locked_out table. Otherwise, if there’s no match, the statement returns
SELECT *FROM usersWHERE EXISTS (SELECT user_id FROM locked_out WHERE locked_out.user_id = users.user_id);
Looking to contribute?
- Learn more about how to get involved.
- Edit this page on GitHub to fix an error or make an improvement.
- Submit feedback to let us know how we can improve Docs.
Learn SQL on Codecademy
Analyze Data with SQLLearn to analyze data with SQL and prepare for technical interviews.
Includes 8 Courses
Design Databases With PostgreSQLLearn how to query SQL databases and design relational databases to efficiently store large quantities of data.
Includes 5 Courses