Writing CASE WHEN Statements in SQL (IF/THEN)

Writing CASE WHEN Statements in SQL (IF/THEN)

Becoming a Data Scientist

4 года назад

84,197 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@adityadalvi7884
@adityadalvi7884 - 20.12.2023 10:02

Thanks

Ответить
@attrinh8343
@attrinh8343 - 19.12.2023 20:07

verry good content

Ответить
@user-ft7bi6qc8i
@user-ft7bi6qc8i - 02.12.2023 17:43

Thank you so much for the help

Ответить
@vaidehishah8867
@vaidehishah8867 - 22.11.2023 02:42

These videos were really helpful! Thanks a ton!

Ответить
@BessieMartin-cl8sz
@BessieMartin-cl8sz - 08.11.2023 17:42

interest!

Ответить
@itzyfan88
@itzyfan88 - 20.09.2023 22:01

Very clear, thanks

Ответить
@pv6010
@pv6010 - 16.08.2023 10:48

u r the man, thankxxxxxxx

Ответить
@charmalvarez9717
@charmalvarez9717 - 19.07.2023 10:02

thank you so much, did you stop posting videos?

Ответить
@yotsusan_machi
@yotsusan_machi - 11.02.2023 09:34

thank kyu mr

Ответить
@griffinwillig4329
@griffinwillig4329 - 05.02.2023 04:56

Dude, you are legit the best. I have watched so many Coursera's and taken so many classes, and you by-far explain everything THE BEST. Keep on rocking.

Ответить
@embisonjones4996
@embisonjones4996 - 06.01.2023 11:57

That you Nathan. You’ve earned a new subscriber

Ответить
@anne7983
@anne7983 - 12.11.2022 00:54

Just the tutorial I need. Thank you so much!🤩

Ответить
@Helloimtheshiieet
@Helloimtheshiieet - 21.10.2022 15:03

Ok... but not if you do case when XYZ AND ABC then 1 else 0...

Ответить
@BRAloni
@BRAloni - 09.10.2022 08:53

how to Write a query to display EMPLOYEES having ID 101,102,103 as per the
below order: 1. 101, 2. 103, 3. 102 (Hint: Union Operator / Case Statement)
QUERY

Ответить
@Leopar525
@Leopar525 - 17.09.2022 15:00

I love your content but you should zoom in a bit.. too much empty space and we cannot see the letters without high definition when on mobile

Ответить
@Leopar525
@Leopar525 - 17.09.2022 15:00

I love your content but you should zoom in a bit.. too much empty space and we cannot see the letters without high definition when on mobile

Ответить
@Leopar525
@Leopar525 - 17.09.2022 15:00

I love your content but you should zoom in a bit.. too much empty space and we cannot see the letters without high definition when on movile

Ответить
@serenereader
@serenereader - 31.08.2022 11:54

You are an excellent teacher. Thank you!

Ответить
@alexg97343
@alexg97343 - 19.08.2022 15:57

Great explanation

Ответить
@timothyhallbeck9853
@timothyhallbeck9853 - 17.08.2022 07:00

Good intro into Case, thanks.

Ответить
@nextdoortechieaminfirnash6002
@nextdoortechieaminfirnash6002 - 29.07.2022 06:11

It was right to the point. Thank you for a wonderful lesson.

Ответить
@higiniofuentes2551
@higiniofuentes2551 - 23.07.2022 02:30

Thank you for this very useful video!

Ответить
@anthonynorman1212
@anthonynorman1212 - 19.07.2022 13:45

Your Video was perfect! Thank You

Ответить
@prajith1202
@prajith1202 - 05.07.2022 13:31

Where is the if condition?

Ответить
@96aditishah
@96aditishah - 19.06.2022 13:01

Great explanation! Thanks

Ответить
@simondreyfuss754
@simondreyfuss754 - 12.06.2022 17:29

Jurassic Park: We're gonna make a fortune with this script....

Ответить
@sailoben
@sailoben - 08.05.2022 11:05

I have been engaged to Udemy couse on MS SQL server, but some explainations are hard to understand. Whenever I have doubt This is where I go to. Keep making videos please. Thanks

Ответить
@prasadkhairnar7915
@prasadkhairnar7915 - 10.01.2022 06:09

thanks : )

Ответить
@ravinderthakur7973
@ravinderthakur7973 - 25.11.2021 22:30

Thx a lot, it helps me a lot

Ответить
@factorise001
@factorise001 - 12.11.2021 09:00

waiting for new videos!!

Ответить
@harshavardhank9915
@harshavardhank9915 - 26.07.2021 14:42

please use single quotes otherwise it won't work

Ответить
@trangle2142
@trangle2142 - 03.07.2021 16:24

Very helpful, thank you. I am saving it. Look forward to more videos.

Ответить
@stevencarv-buc3163
@stevencarv-buc3163 - 14.06.2021 14:08

Y repentinamente un comentario en español xD
Es justo lo que estaba buscando, te agradezco.
Este canal es extremadamente útil.
¡un saludo Nathan!

Ответить
@andyn6053
@andyn6053 - 16.05.2021 02:01

more sql videos pls :)

Ответить
@butchdavis2062
@butchdavis2062 - 11.05.2021 11:30

Subscribed big time, thank you brother

Ответить
@mishraadityaanandeavmjejdt265
@mishraadityaanandeavmjejdt265 - 05.05.2021 08:46

Thank you so much for such a great content . It really helped me a lot.

Ответить
@karlderkastn7012
@karlderkastn7012 - 04.05.2021 12:24

tomorrow is my final exam, thanks :)

Ответить
@MichaelFlenderson
@MichaelFlenderson - 23.04.2021 04:50

Thank you! You’re a good teacher 🙏🏻

Ответить
@valentinacoy7757
@valentinacoy7757 - 22.03.2021 04:17

Your videos are amazing, thank you so much!!!

Ответить
@deadbrain1861
@deadbrain1861 - 18.03.2021 23:24

Thank u I watched all sql playlist u r the best

Ответить
@krystianeotis6479
@krystianeotis6479 - 18.03.2021 01:01

Your videos have been so helpful. Thank you!!!

Ответить
@thewaifupillow
@thewaifupillow - 16.03.2021 00:31

Awesine series, can you do one on correlated subqueries?

Ответить
@andrewkorneychuk586
@andrewkorneychuk586 - 06.03.2021 06:50

Just want to say thank u for this great mysql tutorials

Ответить
@manavsaxena5579
@manavsaxena5579 - 28.02.2021 11:53

Hey man, awesome tutorials. Is there anything coming on Window Functions?

Ответить
@xesiusprime9360
@xesiusprime9360 - 16.02.2021 00:56

right on man thanks very helpful and informative supplementation of my education when i dont understand them in how they describe it

btw im wondering, I am almost done my SQL and i heard that i could find a foot in the door kind of job with just SQL. Is this true? how do i find it?

Ответить
@LucHayman
@LucHayman - 11.02.2021 20:36

Awesome thank you!
Is it possible to add multiple case statements in one query? How would I do that?

Ответить
@abdulsami5843
@abdulsami5843 - 01.02.2021 10:42

good tutorial, I am a bit confused about the sum(frieght) shouldn't the sum be increasing as we go down ?

Ответить
@user-cz7tk3gh6w
@user-cz7tk3gh6w - 21.01.2021 20:23

good job

Ответить
@ukaszk.8305
@ukaszk.8305 - 14.01.2021 19:13

I'm using your videos as quick (yet pretty comprehensive!) introductions to the topics you cover. For that, you go at a perfect pace and level of detail for me. And you are always to the point, with no excessive intros. Simplicity is great! The overall quality is also pretty good. Thanks a lot for all your work and enthusiasm. Please keep going! :)

Ответить