Question · SQL and MySQL course · Module 8: Subqueries

The IN operator with a subquery

What is the IN operator combined with a subquery used for?

Answer options

  • To sort results in ascending order
  • To check whether a value is on the list of results returned by the subquery
  • To count the rows in a table
  • To remove duplicates from a single column

You can check the correct answer by solving this task in the CodeWorlds game.