Writing CASE WHEN Statements in SQL (IF/THEN)

Step-by-step tutorial shows you how to use the CASE WHEN statement in SQL to execute IF/THEN statements that customize your output!
Get the Northwind Database: • How to Load a Sample P...
Support the Channel:
1) Subscribe: www.becomingads.com/o/youtube
2) DataCamp:
3) Udacity:

[@sarahemslie6105]

An afternoon binge-watching your SQL videos is time well spent! Thank you for taking the time to make them. Subscribed.

[@becomingADS]

That's awesome Sarah!! So happy to have helped ya out!

[@ukaszk.8305]

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! :)

[@griffinwillig4329]

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.

[@MichaelFlenderson]

Thank you! You’re a good teacher 🙏🏻

[@anne7983]

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

[@ANUJYADAV-dj1iq]

i have gone through many videos on youtube but I find my solution here at the end. thanks for making this video.

[@krystianeotis6479]

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

[@serenereader]

You are an excellent teacher. Thank you!

[@valentinacoy7757]

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

[@vaidehishah8867]

These videos were really helpful! Thanks a ton!

[@nextdoortechieaminfirnash6002]

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

[@andrewkorneychuk586]

Just want to say thank u for this great mysql tutorials

[@stevencarv-buc3163]

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

[@mishraadityaanandeavmjejdt265]

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

[@12245Fred]

Amazing explanation, thank you this helped a lot

[@deadbrain1861]

Thank u I watched all sql playlist u r the best

[@embisonjones4996]

That you Nathan. You’ve earned a new subscriber

[@anthonynorman1212]

Your Video was perfect! Thank You

[@jordanroywhite]

Thanks so much for the great video!

[@dawitworku821]

It's very helpful! Thank you.

[@higiniofuentes2551]

Thank you for this very useful video!

[@user-ft7bi6qc8i]

Thank you so much for the help

[@96aditishah]

Great explanation! Thanks

[@ravinderthakur7973]

Thx a lot, it helps me a lot

[@darylfgeorge]

great video, thank you!

[@butchdavis2062]

Subscribed big time, thank you brother

[@showutheworld]

Your videos are awesome!!! I'm currently taking a course and your second explanation is exactly what I need to understand the concepts better! Thank you! Please continue :) Already subscribed.

[@MartinFaehrmann]

Very helpful video, thank you :)

[@itzyfan88]

Very clear, thanks

[@pv6010]

u r the man, thankxxxxxxx

[@ashokandhra2268]

Thank you... It's helpful

[@timothyhallbeck9853]

Good intro into Case, thanks.

[@alexg97343]

Great explanation

[@mazinmohammed6624]

please continue with the database videos, if you could do some on T-SQL and SSM it'd be great!

[@gonzalomartinez1575]

Thanks very useful

[@wiktor18071]

Supporting the excellent wrk:)

[@becomingADS]

You're the best!

[@max1qin927]

Hi Nathan, your videos are amazing. I watched all about sql and helped me a lot. I find you stop uploading new videos. Could you please do your video again. I am sure they help a lot of people on the planet of Earth.

[@LucHayman]

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

[@KevinTempelx]

Thanks!

[@attrinh8343]

verry good content

[@simondreyfuss754]

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

[@sailoben]

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

[@adityadalvi7884]

Thanks

[@manavsaxena5579]

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

[@prasadkhairnar7915]

thanks : )

[@factorise001]

waiting for new videos!!

[@user-cz7tk3gh6w]

good job

[@abdulsami5843]

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

[@xesiusprime9360]

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?

[@yotsusan_machi]

thank kyu mr

[@thewaifupillow]

Awesine series, can you do one on correlated subqueries?

[@montieeaster9883]

Can the Then output be another column rather than a text?

[@christleiroezi8878]

Hello, I have a huge Case statement query that groups a column into buckets, I am trying to count how many patients are in each bucket, How do I do that?The case statement does let me use the count function. Thanks

[@andyn6053]

more sql videos pls :)

[@ViciousZeroEnder]

DO MORE SQL VIDEOS PLEASE!!!!

[@kellensampson289]

Question: is it possible to then sort out your results so that all the customers within the same weight range are listed together? For example, all the "heavy" customers are ordered first, then all the "medium" customers, then all the "light" customers? All within the same output?

[@ViciousZeroEnder]

if you do order by freight it would effectively do what ur askin

[@kanknw]

Can you make video about solving complex sql problem

[@karlderkastn7012]

tomorrow is my final exam, thanks :)

[@BRAloni]

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

[@BessieMartin-cl8sz]

interest!

[@charmalvarez9717]

thank you so much, did you stop posting videos?

[@danielmejia8530]

Very Nice. Can I use logic after WHEN? let's say: WHEN (condition_A AND condition_B) THEN something.

[@vigneshiyer2424]

Yes, you can.

[@Leopar525]

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

[@Yarunooo]

SELECT UnitsOnOrder, CASE
WHEN UnitsOnOrder > UnitsInStock THEN 'a'
else 'test'
End as BestellingenStock
FROM Orders;
01:46:40 SELECT UnitsOnOrder, CASE WHEN UnitsOnOrder > UnitsInStock THEN 'a' else 'test' End as BestellingenStock FROM Orders LIMIT 0, 2000 Error Code: 1054. Unknown column 'UnitsOnOrder' in 'field list' 0.016 sec

[@Leopar525]

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

[@praji1202]

Where is the if condition?

[@Helloimtheshiieet]

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

[@mujtaba135]

Need Help !!!!!!!!!!!

[@harshavardhank9915]

please use single quotes otherwise it won't work

Thanks

[@Leopar525]

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