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