SUBSTR IN SQL WITH EXAMPLES | MASTER IN SQL

[@ilolita_]

GH..LOVE your SQL tutorials. So clear. thank you

[@hamedkhan5597]

SUBSTR('LAUGH', 4,3) IS GH. Thanks for your video. Very good explanation. Thanks again.

[@spl26channel45]

Sure

[@rajendrapadamata4105]

It's GH

[@konulaslan]

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

[@parthshah5171]

This is great! Keep the SQL videos coming.

[@crackconcepts]

Thank you!

[@dkarcade_]

Thank you for explaining that indexing is always left to right. Makes SO much more sense now.

[@jannelledear2645]

I was stuck and this tutorial helped me so much! Thank you.

[@rajuprashanth1277]

GH Answer for this.... I really learnt Sql from ur classes... Thanks a lot sissy 👍👍

[@edgetransit3320]

Brilliant teaching. Simplicity now I understand clearly!

[@tinu118]

Came in to figure out how Substring function is used, ended up with complete understanding. Thank you for the tutorial ^_^.

[@rameshtiru9509]

The best youtuber 🥰
I learned so much from this channel

[@liveurlife11100]

Thanks sis for this nice explanation. Now I clearly understand about how substring function is used

[@aryanbawa8711]

Sadia thanks for best and brief explanation for sql ......

[@fredh3152]

The reason your tutorial is good is because you use a good example exercise

[@mdazharuddin5804]

My doubt are clear after watching this video. Thank you sadiya ji. Keep going

[@sidheshwerprajapati2924]

Very Nice Approach for explaination.... easiest way to learn 🙂

[@shankarjaya298]

Really helpful...thank you for such an amazing explanation 🙏

[@srikarthik8775]

Vidieo on Substr was gr8 ... plz make video on instr also same like thz ... ?

[@scrt1111]

Thanks very simple method to understands ..Take care

[@md.shihabmustafa6688]

Nice work!!! Well explained!!!!!!!!!

[@xootttv7590]

Thanks for the awesome video. Explained very nicely

[@jatinpareta439]

Nice explanation kep it up😁.

[@jitendraverma3783]

Very helpful
Thankyou Sadiya👍
Keep it up 👍

[@raj_rp18]

THE ANSWER FOR *SUBSTR(LAUGH,4,3) =GH
AND THANKS FOR THE EXPLANATION ..🙏🥰

[@tanuzztanu9434]

Substring ('LAUGH' ,4,3);
Output: GH

[@surenhta]

That was clear n concise.. thanks tutor.. 😊

[@Aksinia1599]

Thank you so much! Very clear and informative.

[@ahmedaj2000]

thanks! very good explanation

[@avinash12ful]

Thank you very much for Explain in details.

[@nikhilsoni470]

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 ?

[@AjayKumar-rz6hz]

GH will be the answer🙌

[@HappyMoonByH]

GH🤟🤭

[@jatinpareta439]

GH WIILL BE THE ANSWER

[@Vanaja.Arigala]

Very clearly I understand thank you so much

[@mohammedasif4349]

Ans will be GH for your question... You teach really well BTW. 🙂

[@pratimasingh7336]

This is awsome video

[@AnshulMarele-gbaa]

How to enable viewing syntax and command definition [while typing any command] in MS-SQL as we see in Excel

[@Harshk2501]

Better explained then any other video

[@srikarthik8775]

Substr was gr8 ... plz make video on instr also same like thz ... ?

[@tradingaddiction621]

good job

[@aditya_kittu22]

Substr('laugh',4,3) is GH

[@mylittleherodev247]

How two extract value in between first two slashes

[@sibanikumarisethi7348]

Answer will be GH
Tq
I didn't understand minus concept becoz of this vedio my concept was clear.... 🙂

[@ltcmdc1782]

GH with a leading space.🤣

[@shihabdsr]

Really helpful thank you

[@abhishekhbaliarsingh711]

Nice explanation 🎉

[@kblak21]

--> GH ... thank you for making this content

[@shwetabudake6144]

Very well explained

[@mayurtambe7164]

thank you ,
nice explanation

[@sarathchitluri5224]

Nice explanation

[@swapnaram8799]

GH is the answer.. thanks mam 🙏

[@paritoshkumar9062]

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.

[@gdejandespotovic]

nice example, tnx ;)

[@oylesinehesap6490]

Thanks it helped a lot!

[@nelsonlakhani9160]

IA

[@shivamkohli348]

Mam answer is 'gh'

[@abhishekcpc5044]

GH
If I wanted to print the second last row of table using SQL, what is the query

[@kodakandlapreethi526]

Do group by and get it

[@whencat4705]

Select * from tablename order by columnname desc/asc limit 1,1

[@m.s.k5300]

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;

[@MadhuSudhan-nn6bd]

Thank you ya!

[@deepu9356]

GH is the answer for the last query.

[@evasanchezinche605]

sooo easy and quick to get it thank you!

[@shivavishwakarma7109]

Thanks ma'am

[@ampsquadshorts]

GH in last

[@choke92]

SUBSTR ( 'ATHANKSQ', 2 , 6) Sadia!

[@GISITTools]

you are going well

[@abhinavsiripuram4130]

G H

[@vamsiraavi8496]

GH❤

[@LaurenZAI]

Thanks!

[@atulsoni5207]

Very useful

[@hanasamjath2486]

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()?

[@Arunkumar-ke1gq]

The output is : GH
GH -government hospital 😅

[@itsAj777]

👉 GH

[@sakshipunjaban]

Ans: GH

[@charanteja.k6410]

=> SELECT SUBSTR('LAUGH',4,3) FROM DUAL;
RESULT WILL BE: GH.

[@hussainkhan2892]

Ans:GH..
tumhari is class ke liya shukriya

[@rithigagovindarajan3923]

Thank You ji

[@prabhasaha6030]

GH☺

[@srikarthik8775]

Superb

[@rangamadar8929]

Thank you mam

[@kaushikkhanra941]

GH

[@kapilgangawane]

💯

[@SaiTeja-pj7ws]

GH MAM THANK YOU

[@anweralam18791]

'GH' will be the answer

[@saipeluri1747]

Medam i want to last character of the name without using - how medam

[@nikhathtarannum2060]

How to apply substring for a column

[@charanteja.k6410]

COULD YOU EXPLAIN IN-STRING TOPIC PLEASE.......

[@nikhathtarannum2060]

How to apply substring for whole column

[@darshanchopra4823]

GH .... - ANSWER

[@swathireddy7688]

GH, because after H there is no letter so that's y

[@minhazulsayem4607]

Thank you

[@raghulrn5898]

GH is the answer

[@sbstoryteller499]

Thank you so much

[@akshaysharma885]

Hi Sadia

[@nikhilyadav5151]

answer gh?

[@titan-ds8sm]

😇🙏🏻

[@Aditya_raj_17]

GH, and yes thank you!

[@santoshzone2569]

I have some doubt about string functions

[@Kae8]

O/P GH

[@firdaushaslin2839]

thanks

[@PrakashKumar-xi4ot]

Super ❤️❤️

[@nobara_izumaki]

how it works when we put none value in substr like ( , 3 )

[@Kae8]

Thanks alot