MENU
Question -

Sonal needs to display name of teachers, who have “0” as the third character in their name. She wrote the following query.
Select name from teacher where name = “$$0?”; But the query isn’t producing the result. Identify the problem.



Answer -

The wildcards are incorrect. The corrected query is SELECT name FROM teacher WHERE name
LIKE’ _ _  0%’

Comment(S)

Show all Coment

Leave a Comment

Free - Previous Years Question Papers
Any questions? Ask us!
×