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:
A. Select *from customers where city=’%GAR%’;
B. Select *from customers where city=’$GAR$’;
C. Select *from customers where city like ‘%GAR%’;
D. Select *from customers where city as ’%GAR’;
Answer:C
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:
A. Select *from customers where city=’%GAR%’; B. Select *from customers where city=’$GAR$’; C. Select *from customers where city like ‘%GAR%’; D. Select *from customers where city as ’%GAR’;