SQL quiz. Pick all queries equivalent to the following one:

Pick all queries equivalent to the following one:

select * from numbers where textvalue = 'one'

select * from numbers where textvalue like '%one%'

select * from numbers where textvalue like '%one'

select * from numbers where textvalue like 'one'

select * from numbers where textvalue like 'one%'

select * from numbers where textvalue like one

Explanation

% wildcard character matches zero, one or more characters in a string.

like-operator

or Read more about SQL Quizzes