Special WHERE operators

Range queries revealed

Report a typo

Which SQL query correctly retrieves rows for users whose age is between 30 and 40 inclusive, and ensures the age value is not NULL?

Select one or more options from the list

SELECT * FROM Users WHERE Age >= 30 AND Age <= 40 AND Age IS NOT NULL;

SELECT * FROM Users WHERE Age BETWEEN 30 AND 40 AND Age IS NOT NULL;

SELECT * FROM Users WHERE Age >= 30 AND Age <= 40;

SELECT * FROM Users WHERE (Age = 30 OR Age = 40) AND Age IS NOT NULL;

SELECT * FROM Users WHERE Age IN (30, 40) AND Age IS NOT NULL;

Create a free account to access the full topic