EXISTS Operator

This lesson discusses the EXISTS operator.

In this lesson we’ll learn about the boolean operator EXISTS and its complement, NOT EXISTS. The EXISTS operator is usually used to test if a subquery returns any rows or none at all.

Connect to the terminal below by clicking in the widget. Once connected, the command line prompt will show up. Enter or copy and paste the command ./DataJek/Lessons/33lesson.sh and wait for the MySQL prompt to start-up.

Level up your interview prep. Join Educative to access 70+ hands-on prep courses.