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

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🙏👌

finished watching

well explained thanks for that

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

Thank you bhai - ( for the Case statement )

Really very good explanation bro

Very nice and informative SQL videos
Thank you very much

Thank you so much sir

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

good work. Keep it up

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

The kind of explanation is good ''Mehengawala'', ''Sastawala''. 😂😂

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👍👏🙌

Thanks bro ❤

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

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

Bhola not sab kuch it is all records...you are a real Bhola urf Tambola🤣🤣🤣

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

Well explained Sir👍

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?

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

SELECT sab_kuch FROM payments 🤣🤣🤣

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

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

Bhai odia ki?

Business Analyst Cours ka full tutorial bnay hindi me plz sir

Brother power bi kaha se Sikhe hindi me

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