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

SQL Full Course Playlist 👇

Like, Share & Subscribe Now :)
➖➖➖➖➖➖➖➖➖➖➖➖➖

➖➖➖➖➖➖➖➖➖➖➖➖➖
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

Data Types, Primary-Foreign Keys & Constraints in SQL | SQL Tutorial In Hindi 2

Create Table In SQL & Create Database | SQL Tutorial In Hindi 3

INSERT UPDATE, DELETE & ALTER Table in SQL With Example | SQL Tutorial in Hindi 4

SELECT Statement & WHERE Clause with Example | Operators in SQL | SQL Tutorial in Hindi 5

How To Import Excel File (CSV) to SQL | Import Data From File | SQL Tutorial in Hindi 6

String Functions in SQL | Functions in SQL | SQL Tutorial in Hindi 7

Aggregate Functions in SQL - COUNT, SUM, AVG, MAX, MIN | SQL Tutorial in Hindi 8

Group By and Having Clause in SQL | SQL Tutorial in Hindi 9

TimeStamp and Extract Function | Date Time Function | SQL Tutorial in Hindi 10

Complete SQL JOINS For Beginners | SQL JOIN Queries with Examples | SQL Tutorial in Hindi 11

SQL SELF JOIN | UNION & UNION ALL in SQL | SQL Tutorial in Hindi 12

Complete SQL Subquery Using Comparison and Logical Operators | SQL Tutorial in Hindi 13

SQL Window Function with Example- RANK, DENSE RANK, ROW NUMBER, LEAD/LAG | SQL Tutorial in Hindi 14

Useful videos
How to Become Data Analyst in 2022 | Data Analyst Roadmap

Data Analyst skills, jobs and Roadmap

Excel Tutorial for Beginners

➖➖➖➖➖➖➖➖➖➖➖➖➖
Connect on other Social Media handles:

➖➖➖➖➖➖➖➖➖➖➖➖➖

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!

[Khan-mcgi]

I am non i.t background i was thinking sql will be difficult for me to learn then i start watch your video u made us sql very easy and explain outstanding way to sql u are great person thanks alot sir👍👏🙌

[arhaam_val]

Thank you so much for this tutorial! 3 weeks of SQL done, started 4th week today. 🎉

[kaminibobade]

You have explained it in superb way, thank you so much and please share more projects of sql

[rithikahuja]

Greatest and easiest explanation of every topic ❤❤thank you rishabh bhaiya for this tutorial

[Travelling_With_Kamalu]

Thank you bhai - ( for the Case statement )

[himanshumalik]

hello Rishabh, firstly I would like to say thank you for all the videos that you have uploaded regarding SQL, I have learned lots of things from here, my problem is I am unable to recognize which query I should use for which scenario . do you have any suggestion for that ??

[turkeyjobsprovider]

Business Analyst Cours ka full tutorial bnay hindi me plz sir

[mahendraprajapati]

Very nice and informative SQL videos
Thank you very much

[prasadharihar]

good explain thank you rishabh sir .sql kabhi sikhi nhi thi abhi kafi kuch sikh gaya apki simple tariko se kafi simple lag raha hai thank you for all🙏👌

[himanshubhatt]

SO i want to ask that what is requirement of case statement if we can get values from case expression
please tell me, i have become ur fan

[noumanibrahim]

Thanks for aplaod these awesome lectures but please also drop link of data set in description.

[balikatawale]

Ek table hai jisme ek age column hai usme query lagani hai jisse age smaller than 18 is child and age greater than 18 is adult ho

[Mr.tricks.]

sir mera es baar error araha hai
LINE 3: WHEN amount > 50 then 'expensive product'
^
how to solve this error sir please reply

[SC-mxwp]

BHAI, 99% APNE BOLA VAISE HI HOTA HAI 🎉🎉🎉😂❤

[biswajeetdhal]

Sir, how to write case statements using CTE?? please can you tell..

[SagarKumar-nhno]

Sir, if possible, please upload the video on daily basis and complete this course..

[harshamannem]

Bro. I think you have confused difference between simple and searches case statements with difference of case statements and expressions. The concept you explained in this video is simple and searched case expressions

[lupinarsene]

Does this "case statement" stores the data temporarily? Because after this case i used only select * from ___. that case values didnt show up. what might be the error?

[sachinkuchgave]

Can you please tell me how to wtite query when cust_id is null then cust_name should be 'not applicable'

[kareem]

sir its coming as syntax error in postgre sql 15 at when statement
query i wrote is same as yours
SELECT customer_id, amount
CASE
WHEN amount > 70 THEN 'Expense Product'
WHEN amount = 70 THEN 'Moderate Product'
Else 'Inexpensive'
END AS Product,
From payment