What is the answer? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
21st Feb 2019, 5:10 PM
FirstSoloKiller
FirstSoloKiller - avatar
6 Answers
+ 9
I presume '%wolf' be the answer. The '%' before 'wolf' there is an asterisk indicating that any word(s) preceding the word 'wolf' are considered as good candidate to be selected. A 'black wolf', 'grey wolf' or 'white wolf' will be included in the query result set, notice the similarity, they all ends with word 'wolf', whatever precedes the word 'wolf' doesn't matter. Hth, cmiiw
21st Feb 2019, 6:57 PM
Ipang
+ 11
Thanks but the answer is %wolf
21st Feb 2019, 6:53 PM
FirstSoloKiller
FirstSoloKiller - avatar
+ 3
like operator is used check an incomplete strings the above %wolf is the example it will return the rows of a table in which the animal name ends with wolf query select * from Zoo where animal like ‘%wolf’;
22nd Feb 2019, 4:13 AM
sree harsha
sree harsha - avatar
+ 1
LIKE is a SQL key word which means anything between the quotions be like the equivalent of the column name before it which animal In your case the answer should be 'wolf' Zoo is a table that has animal and age fields the animal field includes many wolves and all wolves has the 'wolf' word so we need to get all them to get their ages that's why we use the LIKE word I hope was that clear
21st Feb 2019, 5:50 PM
Ameer Abdulaziz
Ameer Abdulaziz - avatar
0
سلام
25th Feb 2019, 3:50 PM
mohammad
0
SQL is a structured or sequencel querry language it is used dbms problematical
28th Feb 2019, 4:00 PM
B VENKATESH
B VENKATESH - avatar