Тёмный

SUBSTR IN SQL WITH EXAMPLES | MASTER IN SQL 

Crack Concepts
Подписаться 129 тыс.
Просмотров 77 тыс.
50% 1

Опубликовано:

 

27 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 222   
@ilolita_
@ilolita_ 4 года назад
GH..LOVE your SQL tutorials. So clear. thank you
@hamedkhan5597
@hamedkhan5597 3 года назад
SUBSTR('LAUGH', 4,3) IS GH. Thanks for your video. Very good explanation. Thanks again.
@spl26channel45
@spl26channel45 2 года назад
Sure
@rajendrapadamata4105
@rajendrapadamata4105 Год назад
It's GH
@konulaslan
@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
@jannelledear2645
@jannelledear2645 2 года назад
I was stuck and this tutorial helped me so much! Thank you.
@parthshah5171
@parthshah5171 4 года назад
This is great! Keep the SQL videos coming.
@crackconcepts
@crackconcepts 4 года назад
Thank you!
@dkarcade_
@dkarcade_ Год назад
Thank you for explaining that indexing is always left to right. Makes SO much more sense now.
@edgetransit3320
@edgetransit3320 3 года назад
Brilliant teaching. Simplicity now I understand clearly!
@tinu118
@tinu118 3 года назад
Came in to figure out how Substring function is used, ended up with complete understanding. Thank you for the tutorial ^_^.
@rajuprashanth1277
@rajuprashanth1277 4 года назад
GH Answer for this.... I really learnt Sql from ur classes... Thanks a lot sissy 👍👍
@liveurlife11100
@liveurlife11100 2 года назад
Thanks sis for this nice explanation. Now I clearly understand about how substring function is used
@rameshtiru9509
@rameshtiru9509 3 года назад
The best youtuber 🥰 I learned so much from this channel
@aryanbawa8711
@aryanbawa8711 Год назад
Sadia thanks for best and brief explanation for sql ......
@srikarthik8775
@srikarthik8775 3 года назад
Vidieo on Substr was gr8 ... plz make video on instr also same like thz ... ?
@shankarjaya298
@shankarjaya298 2 года назад
Really helpful...thank you for such an amazing explanation 🙏
@mdazharuddin5804
@mdazharuddin5804 2 года назад
My doubt are clear after watching this video. Thank you sadiya ji. Keep going
@sidheshwerprajapati2924
@sidheshwerprajapati2924 2 года назад
Very Nice Approach for explaination.... easiest way to learn 🙂
@md.shihabmustafa6688
@md.shihabmustafa6688 6 месяцев назад
Nice work!!! Well explained!!!!!!!!!
@jitendraverma3783
@jitendraverma3783 4 года назад
Very helpful Thankyou Sadiya👍 Keep it up 👍
@scrt1111
@scrt1111 3 года назад
Thanks very simple method to understands ..Take care
@xootttv7590
@xootttv7590 2 года назад
Thanks for the awesome video. Explained very nicely
@nikhilsoni470
@nikhilsoni470 3 года назад
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 ?
@ahmedaj2000
@ahmedaj2000 3 года назад
thanks! very good explanation
@jatinpareta439
@jatinpareta439 3 года назад
Nice explanation kep it up😁.
@Aksinia1599
@Aksinia1599 2 года назад
Thank you so much! Very clear and informative.
@srikarthik8775
@srikarthik8775 3 года назад
Substr was gr8 ... plz make video on instr also same like thz ... ?
@sakshipunjaban
@sakshipunjaban 7 месяцев назад
Ans: GH
@surenhta
@surenhta 3 года назад
That was clear n concise.. thanks tutor.. 😊
@raj_rp18
@raj_rp18 2 года назад
THE ANSWER FOR *SUBSTR(LAUGH,4,3) =GH AND THANKS FOR THE EXPLANATION ..🙏🥰
@TECHYVASTU
@TECHYVASTU Месяц назад
very very nice explanation can you make these video in hindi
@avinash12ful
@avinash12ful 3 года назад
Thank you very much for Explain in details.
@oylesinehesap6490
@oylesinehesap6490 2 года назад
Thanks it helped a lot!
@Vanaja.Arigala
@Vanaja.Arigala 3 года назад
Very clearly I understand thank you so much
@tanuzztanu9434
@tanuzztanu9434 2 года назад
Substring ('LAUGH' ,4,3); Output: GH
@Harshk2501
@Harshk2501 3 года назад
Better explained then any other video
@pratimasingh7336
@pratimasingh7336 3 года назад
This is awsome video
@abhishekcpc5044
@abhishekcpc5044 4 года назад
GH If I wanted to print the second last row of table using SQL, what is the query
@kodakandlapreethi526
@kodakandlapreethi526 3 года назад
Do group by and get it
@whencat4705
@whencat4705 3 года назад
Select * from tablename order by columnname desc/asc limit 1,1
@m.s.k5300
@m.s.k5300 3 года назад
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;
@shihabdsr
@shihabdsr Год назад
Really helpful thank you
@fredh3152
@fredh3152 8 месяцев назад
The reason your tutorial is good is because you use a good example exercise
@mohammedasif4349
@mohammedasif4349 2 года назад
Ans will be GH for your question... You teach really well BTW. 🙂
@hanasamjath2486
@hanasamjath2486 2 года назад
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()?
@abhishekhbaliarsingh711
@abhishekhbaliarsingh711 Год назад
Nice explanation 🎉
@paritoshkumar9062
@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.
@mylittleherodev247
@mylittleherodev247 2 месяца назад
How two extract value in between first two slashes
@charanteja.k6410
@charanteja.k6410 3 года назад
=> SELECT SUBSTR('LAUGH',4,3) FROM DUAL; RESULT WILL BE: GH.
@AjayKumar-rz6hz
@AjayKumar-rz6hz 3 года назад
GH will be the answer🙌
@GISITTools
@GISITTools 4 года назад
you are going well
@mayurtambe7164
@mayurtambe7164 2 года назад
thank you , nice explanation
@charanteja.k6410
@charanteja.k6410 3 года назад
COULD YOU EXPLAIN IN-STRING TOPIC PLEASE.......
@evasanchezinche605
@evasanchezinche605 3 года назад
sooo easy and quick to get it thank you!
@tradingaddiction621
@tradingaddiction621 9 месяцев назад
good job
@sarathchitluri5224
@sarathchitluri5224 Год назад
Nice explanation
@shwetabudake6144
@shwetabudake6144 3 года назад
Very well explained
@AnshulMarele-gbaa
@AnshulMarele-gbaa Год назад
How to enable viewing syntax and command definition [while typing any command] in MS-SQL as we see in Excel
@MadhuSudhan-nn6bd
@MadhuSudhan-nn6bd 4 года назад
Thank you ya!
@srikarthik8775
@srikarthik8775 3 года назад
Superb
@nikhilyadav5151
@nikhilyadav5151 Год назад
answer gh?
@LaurenZAI
@LaurenZAI Год назад
Thanks!
@ltcmdc1782
@ltcmdc1782 Год назад
GH with a leading space.🤣
@hussainkhan2892
@hussainkhan2892 2 года назад
Ans:GH.. tumhari is class ke liya shukriya
@ampsquadshorts
@ampsquadshorts Год назад
GH in last
@gdejandespotovic
@gdejandespotovic 2 года назад
nice example, tnx ;)
@rithigagovindarajan3923
@rithigagovindarajan3923 2 года назад
Thank You ji
@sibanikumarisethi7348
@sibanikumarisethi7348 2 года назад
Answer will be GH Tq I didn't understand minus concept becoz of this vedio my concept was clear.... 🙂
@vinay2641
@vinay2641 3 года назад
Ans is GH Mam i am doing bca but i have no interest in c language but i love sql and building my concepts strong, can u please tell what are the job opportunities if we do sql,python
@crackconcepts
@crackconcepts 3 года назад
Data analyst
@vinay2641
@vinay2641 3 года назад
@@crackconcepts what job you do mam ,besides yt?
@nelsonlakhani9160
@nelsonlakhani9160 3 года назад
IA
@santoshzone2569
@santoshzone2569 3 года назад
I have some doubt about string functions
@swapnaram8799
@swapnaram8799 2 года назад
GH is the answer.. thanks mam 🙏
@nikhathtarannum2060
@nikhathtarannum2060 3 года назад
How to apply substring for whole column
@deepu9356
@deepu9356 3 года назад
GH is the answer for the last query.
@shivamkohli348
@shivamkohli348 2 года назад
Mam answer is 'gh'
@nikhathtarannum2060
@nikhathtarannum2060 3 года назад
How to apply substring for a column
@0SIGMA
@0SIGMA 3 года назад
is it possibl to print it in reverse order?
@Arunkumar-ke1gq
@Arunkumar-ke1gq 2 года назад
The output is : GH GH -government hospital 😅
@atulsoni5207
@atulsoni5207 3 года назад
Very useful
@sbstoryteller499
@sbstoryteller499 2 года назад
Thank you so much
@kblak21
@kblak21 2 года назад
--> GH ... thank you for making this content
@PrakashKumar-xi4ot
@PrakashKumar-xi4ot 3 года назад
Super ❤️❤️
@joshua_kitt
@joshua_kitt 9 месяцев назад
SUBSTR ( 'ATHANKSQ', 2 , 6) Sadia!
@ravitentu8267
@ravitentu8267 2 года назад
How to extract the data without counting the position
@dravikrish7323
@dravikrish7323 3 года назад
It’s GH r8?
@nobara_izumaki
@nobara_izumaki 2 года назад
how it works when we put none value in substr like ( , 3 )
@bhavikshah1393
@bhavikshah1393 4 года назад
Wow! Amazing! 💚
@crackconcepts
@crackconcepts 4 года назад
Thanks bhavik!
@shivavishwakarma7109
@shivavishwakarma7109 Год назад
Thanks ma'am
@HappyMoonByH
@HappyMoonByH 3 года назад
GH🤟🤭
@kapilgangawane
@kapilgangawane 2 года назад
💯
@jatinpareta439
@jatinpareta439 3 года назад
GH WIILL BE THE ANSWER
@Kae8
@Kae8 3 года назад
Thanks alot
@darshanchopra4823
@darshanchopra4823 3 года назад
GH .... - ANSWER
@nd8223
@nd8223 2 года назад
Thanks 👍
@saipeluri1747
@saipeluri1747 2 года назад
Medam i want to last character of the name without using - how medam
@vamsiraavi8496
@vamsiraavi8496 10 месяцев назад
GH❤
@kavyakeerthi8701
@kavyakeerthi8701 2 года назад
Thanks a lot
@prabhasaha6030
@prabhasaha6030 Год назад
GH☺
@aditya_kittu22
@aditya_kittu22 2 года назад
Substr('laugh',4,3) is GH
@okotelalex2218
@okotelalex2218 2 года назад
The Result will be GH
@anweralam18791
@anweralam18791 Год назад
'GH' will be the answer
@darshanjain668
@darshanjain668 3 года назад
How to display firstname,middlename and lastname from fullname
@Kae8
@Kae8 3 года назад
O/P GH
@Uzair_Anwar2299
@Uzair_Anwar2299 3 года назад
Index in 0 base or 1 base in sql?
@SohailKhan99788
@SohailKhan99788 Год назад
1
@gajananpatil7877
@gajananpatil7877 3 года назад
THANKS DEAR
Далее
SQL "difference between" interview questions (part 1)
8:20
ДУБАЙСКАЯ ШОКОЛАДКА 🍫
00:55
Просмотров 2,3 млн
Substr and Instr in Oracle|Extracting data from String
15:28
Substring Function in SQL | SQL Tutorial
8:11
Просмотров 3 тыс.
Advanced SQL Tutorial | String Functions + Use Cases
13:49