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

Присоединяйся и изучай SQL

или Узнай больше о Тесты по SQL онлайн