- 1

There are many wolves in the zoo: black wolf, white wolf, lucky wolf, little wolf. They all have 'wolf' at the end of their name

Print the ages of all the wolves. SELECT ages from zoo WHERE animal LIKE ___________ Ans : By using Like Operator : ' % a' = it means search any value which is ending with a; So here Ans ::. '%wolf'

4th Feb 2020, 7:03 PM
JAIN
JAIN - avatar
5 odpowiedzi
+ 4
Hi, Which question did u answer?
4th Feb 2020, 7:08 PM
Oma Falk
Oma Falk - avatar
+ 2
Select column_name from table_name Where column_name like '%wolf'; AS is just used to rename a column at the time of displaying the result. Select column_name AS new_name from table_name
4th Feb 2020, 7:10 PM
Avinesh
Avinesh - avatar
+ 1
Why are you posting a question if you already know the answer to it?
4th Feb 2020, 7:31 PM
Avinesh
Avinesh - avatar
0
Sorry ! May be there is incomplete question, My bad. I'm uploading complete questions ..
4th Feb 2020, 7:14 PM
JAIN
JAIN - avatar
0
'%wolf'
11th Sep 2020, 8:03 PM
OjeifoIduma