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🙏👌
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 ??
i have the same problem. i started learning sql 5 days ago (I'm from a non-tech background).. i think i understand the basic concepts but when i try to solve problems, i get confused about which query to use and I often don't remember the syntax so i have to look at the solution all the time.. is this common for beginners or i need to do anything else? @@RishabhMishraOfficial
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👍👏🙌
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
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
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?
If you want to store it then use update statement instead of select like update tableName set colName = Case When Amt >=500 then "Expensive product" End; try like this and after that use select for display it.
Hi Sagar, this course is almost complete only one last video is left on- CTE (imp topic in sql). Then we will practice advance/complex interview problems on sql
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🙏👌
Glad it was helpful ✅️
@@RishabhMishraOfficial really thank you sir🙏means a lot
I am also Gareeb Customer🤣😂
Business Analyst Cours ka full tutorial bnay hindi me plz sir
Okayy done! will make it soon!
same like for loop in python
sir mera es baar error araha hai
LINE 3: WHEN amount > 50 then 'expensive product'
^
how to solve this error sir please reply
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 ??
Yes, it happens in the beginning. Solution is easy practice more sql questions
i have the same problem. i started learning sql 5 days ago (I'm from a non-tech background).. i think i understand the basic concepts but when i try to solve problems, i get confused about which query to use and I often don't remember the syntax so i have to look at the solution all the time.. is this common for beginners or i need to do anything else? @@RishabhMishraOfficial
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👍👏🙌
The kind of explanation is good ''Mehengawala'', ''Sastawala''. 😂😂
Thank you so much for this tutorial! 3 weeks of SQL done, started 4th week today. 🎉
7:09 Emotional Damage🥹🥲
You have explained it in superb way , thank you so much and please share more projects of sql
Thank you, I will ✨️
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
07:09 jo bhi gareeb hai ham logo ki tarha, bhai kyu hamari le rahe ho UA-cam pe😂😂
Thank you bhai - ( for the Case statement )
Greatest and easiest explanation of every topic ❤❤thank you rishabh bhaiya for this tutorial
Glad you liked it ✨️
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
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
U have to use case statement n update the values based on conditions (age > 18 , etc)
Sample query:
SELECT count(*), * FROM ( select case when age_c
BHAI, 99% APNE BOLA VAISE HI HOTA HAI 🎉🎉🎉😂❤
finished watching
Select sabkuch was 😅fun
Bhola not sab kuch it is all records...you are a real Bhola urf Tambola🤣🤣🤣
Sir, how to write case statements using CTE?? please can you tell..
with cte
as
(
select *,
case
when quantity =3 and quantity
@@datalover120 thanks bro..
Thanks for aplaod these awesome lectures but please also drop link of data set in description.
Done brother, added all the links
Thank you so much sir
Happy to help ✅️
Can you please tell me how to wtite query when cust_id is null then cust_name should be 'not applicable'
Easy,
UPDATE table_name
SET cust_name = 'not applicable'
WHERE cust_id IS NULL
@@RishabhMishraOfficial just want to display it in result set not in table
@@RishabhMishraOfficial dont want to update in table
well explained thanks for that
Glad it helped ✅️
Very nice and informative SQL videos
Thank you very much
Glad you liked it ✅️
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
there is a comma after amount in the select statement
@@piali1234 yeah i solved it beo thanks
maza agaya 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?
If you want to store it then use update statement instead of select like update tableName set colName = Case When Amt >=500 then "Expensive product"
End; try like this and after that use select for display it.
Thank you bro .. Nice teaching
Glad you liked ✅️
Bhai odia ki?
Hi 👋 i m from Prayagraj
🤭😂
You made SQL easy bro!
Glad it helped! ✅️
Really very good explanation bro
Glad you liked it ✅️
good work. Keep it up
Glad you liked ✅️
Thanks bro ❤
Glad you liked it ✅️
Well explained Sir👍
Glad it was helpful ✅️
@@RishabhMishraOfficial yes it was quite helpful 👍😊
Sir, if possible, please upload the video on daily basis and complete this course..
Hi Sagar, this course is almost complete only one last video is left on- CTE (imp topic in sql). Then we will practice advance/complex interview problems on sql