Hey there.god bless your efforts. I am totally sql noob with a simple enquiry. Does both statements below yield the same result or is like different than equal sign in that case. Select * from students WHERE studentname LIKE 'a%' Select * from students WHERE studentname= 'a%' Thanks a lot.
Hello Hasan, Both are not similar. Like operator check for particular character from a string where % will decide the position. Coming to = it will search for exact match, it will display all the studentname with a% not starting or ending with a. Hope you understood. If not contact me on email id mentioned in the description, So that we can discuss more on this
More tutorials from you i watched most of your sql videos
ur class is understable,pls dataset for practice
Super explanation anna, can i have all vedios ppt please 😊
Anna last question with subquery ardam avvaley plz anyone explain [ std qntity > 300] question
Thank, nice explanation andi.
PPT share cheyachu kada andi
Thank you. Reachout to me on info.sritutorials@gmail.com
Need More about Sub quries sir
Thanks for feedback, will try to do a few more on subqueries 👍
Hey there.god bless your efforts.
I am totally sql noob with a simple enquiry.
Does both statements below yield the same result or is like different than equal sign in that case.
Select * from students WHERE studentname LIKE 'a%'
Select * from students WHERE studentname= 'a%'
Thanks a lot.
Hello Hasan,
Both are not similar. Like operator check for particular character from a string where % will decide the position. Coming to = it will search for exact match, it will display all the studentname with a% not starting or ending with a.
Hope you understood. If not contact me on email id mentioned in the description, So that we can discuss more on this
using alias with aggregate fuctions tho cheppu annna