SQL Case When Statement | SQL Fundamentals | SQL Tutorial

In this video we will understand how to work with SQL case when statements . I the end we will discuss a use case as well.

[@vinayp749]

Hello Ankit Bhai,
Thank you very much for your videos. In one video of pivoting and unpivoting you explained using case when with aggregation and also mentioned it as important concept. Can you please elaborate and shed some light on that concept with some use cases so that we can learn where and when to use them
Thank you,
One of your Virtual fan of SQL
Vinay

[@adityeshchaturvedi6553]

Very well explained. Always loved your content.

[@kanchankumar3355]

Good stuff !!

[@ankitbansal6]

Thanks bro 😊

[@sharu164]

Thank you so much Ankit, love your content!

[@venkatgopi1841]

good explanation thanks for the video

[@ankitbansal6]

Welcome

[@mohammedtariq6110]

Really helpful, Thanks a lot

[@ankitbansal6]

Glad it was helpful!

[@abhishek_grd]

I really love your content,

[@priyanshuagrawal1373]

Hi Ankit,
Just want to know if there are so many conditions then we have to use a lot of case statements, is it good practice to use 100 or more than 100 case statements or is there any other way to use this or we should use any other way?
Thanks in advance!
Regards,
Priyanshu

[@moyeenshaikh4378]

can we use count with case when or aggregation functions

[@playtrip7528]

yes we can

[@khandelwalshubham67]

Hello Bhai, could you please cover some more tricky examples on case when statement ?

[@satyamgoyal942]

Great work!! I really love your content, can you please create some videos on regular expression ?

[@ankitbansal6]

Thank you. Sure will do.

[@pavitrashailaja850]

Thnks for the video!

[@ankitbansal6]

Welcome

[@kiransalagala6249]

can we use "OR" in case when statement? I see that you have used AND

[@shubhamchakravorty]

video is awesome but HR people getting 25% raise for making rangolis ? lol #justjoking