Question · SQL and MySQL course · Module 3: Filtering (WHERE)

The BETWEEN operator

Which rows will the condition return: WHERE rok_wydania BETWEEN 1900 AND 2000 ?

Answer options

  • Rows with rok_wydania less than 1900
  • Only rows with rok_wydania equal to 1900 or 2000
  • Rows with rok_wydania from 1900 to 2000 inclusive of both ends
  • Rows with rok_wydania greater than 2000

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