Lesson 14 of 20

Fix a problem with subquery and EXISTS

Break down a question into intermediate results and properly test for the existence of a relationship.

34 minSQL Essentials

By the end of this lesson

  • Write a scalar subquery
  • Use EXISTS for an existence test
  • Choose between join and subquery

SQL Essentials

Continue with the right access

“Fix a problem with subquery and EXISTS” is included from SQL Essentials.

30 free days of SQL Pro on registration, subject to the 33 remaining places. No card or automatic renewal.

Create my Discovery spaceI already have an account
After signing in, you will return directly to this activity.