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👍👏🙌
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
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
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
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.
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
Thank you so much for this tutorial! 3 weeks of SQL done, started 4th week today. 🎉
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👍👏🙌
Greatest and easiest explanation of every topic ❤❤thank you rishabh bhaiya for this tutorial
Glad you liked it ✨️
You have explained it in superb way , thank you so much and please share more projects of sql
Thank you, I will ✨️
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
7:09 Emotional Damage🥹🥲
Thank you bhai - ( for the Case statement )
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
Thank you bro .. Nice teaching
Glad you liked ✅️
Very nice and informative SQL videos
Thank you very much
Glad you liked it ✅️
Thank you so much sir
Happy to help ✅️
maza agaya sir
You made SQL easy bro!
Glad it helped! ✅️
Really very good explanation bro
Glad you liked it ✅️
well explained thanks for that
Glad it helped ✅️
Business Analyst Cours ka full tutorial bnay hindi me plz sir
Okayy done! will make it soon!
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
Thanks for aplaod these awesome lectures but please also drop link of data set in description.
Done brother, added all the links
Well explained Sir👍
Glad it was helpful ✅️
@@RishabhMishraOfficial yes it was quite helpful 👍😊
Thanks bro ❤
Glad you liked it ✅️
finished watching
good work. Keep it up
Glad you liked ✅️
Select sabkuch was 😅fun
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
BHAI, 99% APNE BOLA VAISE HI HOTA HAI 🎉🎉🎉😂❤
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
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..
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
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
I am also Gareeb Customer🤣😂
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.
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
The kind of explanation is good ''Mehengawala'', ''Sastawala''. 😂😂
Bhai odia ki?
Hi 👋 i m from Prayagraj
🤭😂
Bhola not sab kuch it is all records...you are a real Bhola urf Tambola🤣🤣🤣
07:09 jo bhi gareeb hai ham logo ki tarha, bhai kyu hamari le rahe ho RUclips pe😂😂