+ 9
What is the answer?
6 Antworten
+ 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
+ 11
Thanks but the answer is %wolf
+ 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’;
+ 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
0
سلام
0
SQL is a structured or sequencel querry language
it is used dbms problematical