Q. Write a query to display the name of employee whose name contains 'M' as first alphabet 'L' as third alphabet.
Table ---
Answer =
Select ename from Empl
Where ename like “M_L%” ;
Table ---
Answer =
Select ename from Empl
Where ename like “M_L%” ;
Table ---
Answer =
Select ename from Empl
Where ename like “M_L%” ;
the answer will be "m_l%
ReplyDelete"since l is 3rd letter not fourth
Deleteyes you are right
Delete👍👍👍
DeleteOk ...
Delete3rd letter should be L right but you have added M__ before it should be like "M_L%" right.
ReplyDeleteOk. I have corrected.
Deleteare you studying in class 12?
ReplyDeletePost a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )