1.

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» D. Select *from customers where city as ’%GAR’;


Discussion

No Comment Found

Related MCQs