Computer scienceFundamentalsSQL and DatabasesBasics SQLIntroduction to SQL

SQL: structured query language

SQL syntax: boundaries

Report a typo

Take a look at the userstable:

Which query will return all the rows where theyear_of_birth is between 1980 and 2000 (inclusive)?

Select one option from the list

SELECT * FROM users;

SELECT * FROM users WHERE year_of_birth WITHIN(1980, 2000);

SELECT * FROM users WHERE year_of_birth BETWEEN 1980 AND 2000;

SELECT * FROM users BETWEEN 1980 AND 2000;

___

Create a free account to access the full topic