The result for SUBSTR ('LAUGH' , 4, 3) will be => GH. since there is no more letter after H. Your explanations are very clear. Thank you so much, I really appreciate it💐. May the Almighty Creator of us be pleased with you. Amen 🤲 29.05.2023, 16:12
Quick question Is there an equivalent of Isnumeric() function for mysql?....I want to extract all numbers from a string using mysql but I can't find a way.
hi..I dont knownif you'll reply rn but I actually ahve a doubt..in case of substr() if there are 2 words do we include the space between them like mid()?
GH..LOVE your SQL tutorials. So clear. thank you
SUBSTR('LAUGH', 4,3) IS GH. Thanks for your video. Very good explanation. Thanks again.
Sure
It's GH
The result for SUBSTR ('LAUGH' , 4, 3) will be => GH. since there is no more letter after H. Your explanations are very clear. Thank you so much, I really appreciate it💐. May the Almighty Creator of us be pleased with you. Amen 🤲 29.05.2023, 16:12
This is great! Keep the SQL videos coming.
Thank you!
Thank you for explaining that indexing is always left to right. Makes SO much more sense now.
I was stuck and this tutorial helped me so much! Thank you.
GH Answer for this.... I really learnt Sql from ur classes... Thanks a lot sissy 👍👍
Brilliant teaching. Simplicity now I understand clearly!
Came in to figure out how Substring function is used, ended up with complete understanding. Thank you for the tutorial ^_^.
The best youtuber 🥰
I learned so much from this channel
Thanks sis for this nice explanation. Now I clearly understand about how substring function is used
Sadia thanks for best and brief explanation for sql ......
The reason your tutorial is good is because you use a good example exercise
My doubt are clear after watching this video. Thank you sadiya ji. Keep going
Very Nice Approach for explaination.... easiest way to learn 🙂
Really helpful...thank you for such an amazing explanation 🙏
Vidieo on Substr was gr8 ... plz make video on instr also same like thz ... ?
Thanks very simple method to understands ..Take care
Nice work!!! Well explained!!!!!!!!!
Thanks for the awesome video. Explained very nicely
Nice explanation kep it up😁.
Very helpful
Thankyou Sadiya👍
Keep it up 👍
THE ANSWER FOR *SUBSTR(LAUGH,4,3) =GH
AND THANKS FOR THE EXPLANATION ..🙏🥰
Substring ('LAUGH' ,4,3);
Output: GH
That was clear n concise.. thanks tutor.. 😊
Thank you so much! Very clear and informative.
thanks! very good explanation
Thank you very much for Explain in details.
Thank you so much sister for this knowledge. Can you help me in advising which book will be good for a SQL beginner to master ?
GH will be the answer🙌
GH🤟🤭
GH WIILL BE THE ANSWER
Very clearly I understand thank you so much
Ans will be GH for your question... You teach really well BTW. 🙂
This is awsome video
How to enable viewing syntax and command definition [while typing any command] in MS-SQL as we see in Excel
Better explained then any other video
Substr was gr8 ... plz make video on instr also same like thz ... ?
good job
Substr('laugh',4,3) is GH
How two extract value in between first two slashes
Answer will be GH
Tq
I didn't understand minus concept becoz of this vedio my concept was clear.... 🙂
GH with a leading space.🤣
Really helpful thank you
Nice explanation 🎉
--> GH ... thank you for making this content
Very well explained
thank you ,
nice explanation
Nice explanation
GH is the answer.. thanks mam 🙏
Quick question
Is there an equivalent of Isnumeric() function for mysql?....I want to extract all numbers from a string using mysql but I can't find a way.
nice example, tnx ;)
Thanks it helped a lot!
IA
Mam answer is 'gh'
GH
If I wanted to print the second last row of table using SQL, what is the query
Do group by and get it
Select * from tablename order by columnname desc/asc limit 1,1
Select top 1 min(row_number) as rownum
From (select top 2 max(row_num) from table name order by row_num desc)
order by rownum asc;
Thank you ya!
GH is the answer for the last query.
sooo easy and quick to get it thank you!
Thanks ma'am
GH in last
SUBSTR ( 'ATHANKSQ', 2 , 6) Sadia!
you are going well
G H
GH❤
Thanks!
Very useful
hi..I dont knownif you'll reply rn but I actually ahve a doubt..in case of substr() if there are 2 words do we include the space between them like mid()?
The output is : GH
GH -government hospital 😅
👉 GH
Ans: GH
=> SELECT SUBSTR('LAUGH',4,3) FROM DUAL;
RESULT WILL BE: GH.
Ans:GH..
tumhari is class ke liya shukriya
Thank You ji
GH☺
Superb
Thank you mam
GH
💯
GH MAM THANK YOU
'GH' will be the answer
Medam i want to last character of the name without using - how medam
How to apply substring for a column
COULD YOU EXPLAIN IN-STRING TOPIC PLEASE.......
How to apply substring for whole column
GH .... - ANSWER
GH, because after H there is no letter so that's y
Thank you
GH is the answer
Thank you so much
Hi Sadia
answer gh?
😇🙏🏻
GH, and yes thank you!
I have some doubt about string functions
O/P GH
thanks
Super ❤️❤️
how it works when we put none value in substr like ( , 3 )
Thanks alot