SQL Case Statement/Expression with Examples | WHEN THEN ELSE in sql | SQL Tutorial in Hindi 15

Rishabh Mishra β€’ November 19, 2022
Video Thumbnail
Rishabh Mishra Logo

Rishabh Mishra

View Channel

About

Education, Jobs, Career + College Tips πŸ˜‰ Hope you get best out of it and helps you to grow professionally and personally. For queries or collaboration: [email protected]

Video Description

SQL Full Course Playlist πŸ‘‡ https://www.youtube.com/playlist?list=PLdOKnrf8EcP17p05q13WXbHO5Z_JfXNpw Like, Share & Subscribe Now :) ⭐ Subscribe for more SQL tutorials like this: https://bit.ly/3Fc7Gc6 βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž– πŸ‘‰payment csv file: https://bit.ly/41kJLRW πŸ“’ GitHub link (all files): https://bit.ly/3Y7SRPr πŸ“’ βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž– Timestamps: 00:00 Intro 00:11 Case Statement Definition 00:52 Case Statement Syntax 02:16 Case Statement Example 04:48 Case Expression Syntax 06:16 Case Expression Example Target keywords: sql case statement, sql case expression, when then else in sql βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž– Related Videos Introduction to SQL - What Is SQL + Database | SQL Tutorial In Hindi 1 https://www.youtube.com/watch?v=yH1zCq-iaeU Data Types, Primary-Foreign Keys & Constraints in SQL | SQL Tutorial In Hindi 2 https://www.youtube.com/watch?v=HmH-76_2Ak8 Create Table In SQL & Create Database | SQL Tutorial In Hindi 3 https://www.youtube.com/watch?v=v-2cIUgx_jw INSERT UPDATE, DELETE & ALTER Table in SQL With Example | SQL Tutorial in Hindi 4 https://www.youtube.com/watch?v=4YAAgrm8_ZI SELECT Statement & WHERE Clause with Example | Operators in SQL | SQL Tutorial in Hindi 5 https://www.youtube.com/watch?v=eiLqDeDp7Oc How To Import Excel File (CSV) to SQL | Import Data From File | SQL Tutorial in Hindi 6 https://www.youtube.com/watch?v=rfWYbMd3ApA String Functions in SQL | Functions in SQL | SQL Tutorial in Hindi 7 https://www.youtube.com/watch?v=55_UN5gVARs Aggregate Functions in SQL - COUNT, SUM, AVG, MAX, MIN | SQL Tutorial in Hindi 8 https://www.youtube.com/watch?v=9NfthspfXEo Group By and Having Clause in SQL | SQL Tutorial in Hindi 9 https://www.youtube.com/watch?v=SvJLXj05cow TimeStamp and Extract Function | Date Time Function | SQL Tutorial in Hindi 10 https://www.youtube.com/watch?v=kwGh6XvLrEk Complete SQL JOINS For Beginners | SQL JOIN Queries with Examples | SQL Tutorial in Hindi 11 https://www.youtube.com/watch?v=H6988OpZKTU SQL SELF JOIN | UNION & UNION ALL in SQL | SQL Tutorial in Hindi 12 https://www.youtube.com/watch?v=V3xjmBi1QQE Complete SQL Subquery Using Comparison and Logical Operators | SQL Tutorial in Hindi 13 https://www.youtube.com/watch?v=5O2OuN1ougU SQL Window Function with Example- RANK, DENSE RANK, ROW NUMBER, LEAD/LAG | SQL Tutorial in Hindi 14 https://www.youtube.com/watch?v=S1do1EeA7ng Useful videos How to Become Data Analyst in 2022 | Data Analyst Roadmap https://www.youtube.com/watch?v=TiWGpLmYJD4 Data Analyst skills, jobs and Roadmap https://www.youtube.com/playlist?list=PLdOKnrf8EcP1JMcD6PhDsUq8YyC0zMZCM Excel Tutorial for Beginners https://www.youtube.com/playlist?list=PLdOKnrf8EcP1Y1XRUVSUc0g-WfeiBigbd βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž– Connect on other Social Media handles: Instagram: https://www.instagram.com/rishabhnmishra/ LinkedIn: https://www.linkedin.com/in/rishabhnmishra/ Twitter: https://twitter.com/rishabhnmishra βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž– If this is the first ever video you're watching allow me to introduce myself, Hey I'm Rishabh Mishra and currently working as Senior Data Analyst at Bangalore. On this channel I like to guide and help my juniors and data science aspirants regarding Data Science jobs and useful tips for college students. Have a great day buddy!

Upgrade Your Everyday

AI-recommended products based on this video

Loading...
Amazon Echo Show 8 (newest model), With Spatial Audio, Smart Home Hub, and Alexa, Charcoal

Amazon Echo Show 8 (newest model), With Spatial Audio, Smart Home Hub, and Alexa, Charcoal

(21,817)
149.99
PrimeFREE delivery Saturday, June 14
9K+ bought in past month
Loading...
Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, with Active Noise Cancellation, Adaptive Audio, Transparency Mode, Personalized Spatial Audio, USB-C Charging Case, Wireless Charging, H2 Chip
Best Seller

Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, with Active Noise Cancellation, Adaptive Audio, Transparency Mode, Personalized Spatial Audio, USB-C Charging Case, Wireless Charging, H2 Chip

(26,751)
$118.98$114.22
FREE delivery Fri, Oct 17
10K+ bought in past month
Loading...
Wireless Earbuds, Bluetooth 5.4 Headphones, True Wireless Stereo Earphones with IPX7 Waterproof, Noise Cancelling Mic, Fast Charging and Comfort Fit Ear Buds for Sports/Workouts - Black

Wireless Earbuds, Bluetooth 5.4 Headphones, True Wireless Stereo Earphones with IPX7 Waterproof, Noise Cancelling Mic, Fast Charging and Comfort Fit Ear Buds for Sports/Workouts - Black

(1,741)
$19.99
FREE delivery Sun, Jun 22 on $35 of items shipped by Amazon
10K+ bought in past month
Loading...
Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, Personalized Spatial Audio, Sweat and Water Resistant, USB-C Charging Case, H2 Chip, Up to 30 Hours of Battery Life, Effortless Setup for iPhone
Best Seller

Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, Personalized Spatial Audio, Sweat and Water Resistant, USB-C Charging Case, H2 Chip, Up to 30 Hours of Battery Life, Effortless Setup for iPhone

(23,152)
$89.99$83.69
FREE delivery Thu, Sep 4
10K+ bought in past month
Loading...
Apple AirPods Pro 2 Wireless Earbuds, Active Noise Cancellation, Hearing Aid Feature, Bluetooth Headphones, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging

Apple AirPods Pro 2 Wireless Earbuds, Active Noise Cancellation, Hearing Aid Feature, Bluetooth Headphones, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging

(38,487)
$199.00$187.32
FREE delivery Fri, Oct 3
10K+ bought in past month
Loading...
Smart Watch for Men/Women, 1.95" AMOLED Fitness Tracker Watches with Bluetooth Calls/Flashlight/100+ Sport Modes Heart Rate/Sleep Monitor Ultra Lightweight Ultrathin Design

Smart Watch for Men/Women, 1.95" AMOLED Fitness Tracker Watches with Bluetooth Calls/Flashlight/100+ Sport Modes Heart Rate/Sleep Monitor Ultra Lightweight Ultrathin Design

(0)
17.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
Loading...
Smart Watch for Men Women (Answer/Make Call), 1.96" HD Smartwatch Fitness Activity Tracker, 110+ Sports IP68 Waterproof, Heart Rate/Sleep Monitor/Pedometer/Calories, Fitness Watch for Android iOS

Smart Watch for Men Women (Answer/Make Call), 1.96" HD Smartwatch Fitness Activity Tracker, 110+ Sports IP68 Waterproof, Heart Rate/Sleep Monitor/Pedometer/Calories, Fitness Watch for Android iOS

(550)
24.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
100+ bought in past month
Loading...
Apple Watch Series 10 [GPS 46mm case] Smartwatch with Rose Gold Aluminium Case with Light Blush Sport Band - M/L. Fitness Tracker, ECG App, Always-On Retina Display, Water Resistant
Best Seller

Apple Watch Series 10 [GPS 46mm case] Smartwatch with Rose Gold Aluminium Case with Light Blush Sport Band - M/L. Fitness Tracker, ECG App, Always-On Retina Display, Water Resistant

(7,994)
$329.00$296.10
FREE delivery Thu, Jul 3
1K+ bought in past month
Loading...
Apple Watch Series 10 [GPS 42mm case] Smartwatch with Jet Black Aluminium Case with Black Sport Band - S/M. Fitness Tracker, ECG App, Always-On Retina Display, Water Resistant
Best Seller

Apple Watch Series 10 [GPS 42mm case] Smartwatch with Jet Black Aluminium Case with Black Sport Band - S/M. Fitness Tracker, ECG App, Always-On Retina Display, Water Resistant

(7,993)
$299.00$269.10
FREE delivery Thu, Jul 3
8K+ bought in past month
Loading...
NOCO Boost GB40: 1000A UltraSafe Jump Starter – 12V Lithium Battery Booster Pack, Portable Jump Box, Power Bank & Jumper Cables - for 6.0L Gas and 3.0L Diesel Engines
Best Seller

NOCO Boost GB40: 1000A UltraSafe Jump Starter – 12V Lithium Battery Booster Pack, Portable Jump Box, Power Bank & Jumper Cables - for 6.0L Gas and 3.0L Diesel Engines

(117,789)
$99.95$75.43
FREE delivery Sun, Sep 21
30K+ bought in past month
Loading...
UGREEN Nexode Power Bank 20000mAh 130W Portable Charger 72Wh PD Fast Charging 3-Port USB C Battery Pack with TFT Smart Display for MacBook/iPad/iPhone 16/Samsung S24 and More

UGREEN Nexode Power Bank 20000mAh 130W Portable Charger 72Wh PD Fast Charging 3-Port USB C Battery Pack with TFT Smart Display for MacBook/iPad/iPhone 16/Samsung S24 and More

(1,903)
69.99
PrimeFREE delivery Saturday, June 14
500+ bought in past month
Loading...
ANKER 737 Power Bank, 24,000mAh 3-Port Laptop Portable Charger with 140W Fast Charging, Smart Display, for Outdoor Work, Compatible with iPhone 16/15/14 Series, Vision Pro, Samsung, MacBook, and More

ANKER 737 Power Bank, 24,000mAh 3-Port Laptop Portable Charger with 140W Fast Charging, Smart Display, for Outdoor Work, Compatible with iPhone 16/15/14 Series, Vision Pro, Samsung, MacBook, and More

(13,939)
109.99
FREE delivery Saturday, June 14
9K+ bought in past month
Loading...
VOLTME Portable Charger, Slim 10000mAh 5V/3A Power Bank, USB C in&Out High-Speed Charging Battery Pack, Travel Essentials Dual Output Compatible with iPhone 16 15 14 13 12 Samsung Google iPad etc

VOLTME Portable Charger, Slim 10000mAh 5V/3A Power Bank, USB C in&Out High-Speed Charging Battery Pack, Travel Essentials Dual Output Compatible with iPhone 16 15 14 13 12 Samsung Google iPad etc

(51)
19.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
Loading...
Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, with Active Noise Cancellation, Adaptive Audio, Transparency Mode, Personalized Spatial Audio, USB-C Charging Case, Wireless Charging, H2 Chip
Best Seller

Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, with Active Noise Cancellation, Adaptive Audio, Transparency Mode, Personalized Spatial Audio, USB-C Charging Case, Wireless Charging, H2 Chip

(26,751)
$118.98$114.22
FREE delivery Fri, Oct 17
10K+ bought in past month
Loading...
Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, Personalized Spatial Audio, Sweat and Water Resistant, USB-C Charging Case, H2 Chip, Up to 30 Hours of Battery Life, Effortless Setup for iPhone
Best Seller

Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, Personalized Spatial Audio, Sweat and Water Resistant, USB-C Charging Case, H2 Chip, Up to 30 Hours of Battery Life, Effortless Setup for iPhone

(23,152)
$89.99$83.69
FREE delivery Thu, Sep 4
10K+ bought in past month
Loading...
Apple AirPods Pro 2 Wireless Earbuds, Active Noise Cancellation, Hearing Aid Feature, Bluetooth Headphones, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging

Apple AirPods Pro 2 Wireless Earbuds, Active Noise Cancellation, Hearing Aid Feature, Bluetooth Headphones, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging

(38,487)
$199.00$187.32
FREE delivery Fri, Oct 3
10K+ bought in past month
Loading...
Bose QuietComfort Bluetooth Headphones, Wireless Headphones with Active Over Ear Noise Cancelling and Mic, Deep Bass, Up to 24 Hours of Playtime, White Smoke

Bose QuietComfort Bluetooth Headphones, Wireless Headphones with Active Over Ear Noise Cancelling and Mic, Deep Bass, Up to 24 Hours of Playtime, White Smoke

(10,961)
249.00
FREE delivery Wednesday, June 11.
1K+ bought in past month
Loading...
Barnyard Designs Indoor Herb Garden Planter Set with Tray, Metal Windowsill Plant Pots with Drainage for Outdoor or Indoor Plants, Set/3 (Black)

Barnyard Designs Indoor Herb Garden Planter Set with Tray, Metal Windowsill Plant Pots with Drainage for Outdoor or Indoor Plants, Set/3 (Black)

(3,684)
26.95
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
100+ bought in past month
Loading...
Eye Contact Web Camera for Desktop Computer – 1080P USB Camera with Microphone & Stand, Center Cam for Laptop or Desktop, Manual Focus, Plug & Play for macOS & Windows(BlackοΌ‰

Eye Contact Web Camera for Desktop Computer – 1080P USB Camera with Microphone & Stand, Center Cam for Laptop or Desktop, Manual Focus, Plug & Play for macOS & Windows(BlackοΌ‰

(96)
37.39
PrimeFREE delivery Saturday, June 14
100+ bought in past month
Loading...
PEHAEL 3+3Pack for iPhone 17 Pro Max Privacy Screen Protector with Camera Lens Protector Full Coverage Anti-Spy Tempered Glass Film 9H Hardness Easy Installation Bubble Free [6.9 inch]

PEHAEL 3+3Pack for iPhone 17 Pro Max Privacy Screen Protector with Camera Lens Protector Full Coverage Anti-Spy Tempered Glass Film 9H Hardness Easy Installation Bubble Free [6.9 inch]

(151,641)
$7.99$6.39
FREE delivery Mon, Sep 29 on $35 of items shipped by Amazon
New on Amazon in past month
Loading...
Ailun 3 Pack Screen Protector for iPhone 16 Pro Max [6.9 inch] + 3 Pack Camera Lens Protector with Installation Frame,Sensor Protection,Dynamic Island Compatible,Case Friendly Tempered Glass Film

Ailun 3 Pack Screen Protector for iPhone 16 Pro Max [6.9 inch] + 3 Pack Camera Lens Protector with Installation Frame,Sensor Protection,Dynamic Island Compatible,Case Friendly Tempered Glass Film

(362,029)
$7.63
FREE delivery Wed, Aug 20 on $35 of items shipped by Amazon
10K+ bought in past month
Loading...
2025 AI Portable Fan Rechargeable, 4 Speeds 6600RPM Strong Airflow, Personal Waist Fan with up to 25H of Working Time, Hands-Free Hanging Neck Fan, Wearable Belt Fan for Camping, Outdoor, Jobsite

2025 AI Portable Fan Rechargeable, 4 Speeds 6600RPM Strong Airflow, Personal Waist Fan with up to 25H of Working Time, Hands-Free Hanging Neck Fan, Wearable Belt Fan for Camping, Outdoor, Jobsite

(1,636)
$19.98
FREE delivery Thu, Jul 3 on $35 of items shipped by Amazon
40K+ bought in past month