Consider a "CUSTOMERS" database table having a column "CITY" filled with all the names of Indian cities (in capital letters). The SQL statement that finds…
Consider a "CUSTOMERS" database table having a column "CITY" filled with all the names of Indian cities (in capital letters). The SQL statement that finds all cities that have "GAR" somewhere in its name, is :
Show answerHide answer
Correct answer: (C) Select * from customers where city like '%GAR%';
Explanation
The LIKE operator with the % wildcard matches any sequence of characters: Select * from customers where city like '%GAR%';