What does WHERE salary BETWEEN 50000 AND 80000 include?

SQL Data Analyst Easy

SQL Data Analyst — Easy

What does WHERE salary BETWEEN 50000 AND 80000 include?

Key points

  • The BETWEEN operator includes both the lower and upper bounds.
  • This query will return rows with salaries ranging from 50000 to 80000.
  • Option B is incorrect because it excludes the values 50000 and 80000.
  • Option C is incorrect because it only includes rows with salaries exactly equal to 50000 or 80000.

Ready to go further?

Start full exam Practice more questions

Related questions