UGC-NET | UGC NET CS 2015 Dec – II | Question 13

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)

Explanation:

Quiz of this Question
Please comment below if you find anything wrong in the above post