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
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
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
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
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👍👏🙌
Thank you so much for this tutorial! 3 weeks of SQL done, started 4th week today. 🎉
7:09 Emotional Damage🥹🥲
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
Thank you bhai - ( for the Case statement )
Very nice and informative SQL videos
Thank you very much
Glad you liked it ✅️
You made SQL easy bro!
Glad it helped! ✅️
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
Really very good explanation bro
Glad you liked it ✅️
Thank you bro .. Nice teaching
Glad you liked ✅️
Hi could you please make the video where can we build the logic for sql in product based organisations
Thank you so much sir
Happy to help ✅️
Well explained Sir👍
Glad it was helpful ✅️
@@RishabhMishraOfficial yes it was quite helpful 👍😊
well explained thanks for that
Glad it helped ✅️
Thanks sir 🙏
🙏
@@RishabhMishraOfficial SIR Apse Milna h Location Bata sakte Ho janha m Aapse milne aa saku
@@RishabhMishraOfficial Are Sir Batao To
maza agaya sir
good work. Keep it up
Glad you liked ✅️
Thanks bro ❤
Glad you liked it ✅️
7:07
jo log gareeb hai hum logo ki tarahh 🤣😂🤣
kya baat hai sir itna sach nhi bolna tha😅
😅😅
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
Business Analyst Cours ka full tutorial bnay hindi me plz sir
Okayy done! will make it soon!
Select sabkuch was 😅fun
Thanks for aplaod these awesome lectures but please also drop link of data set in description.
Done brother, added all the links
finished watching
Thanks
Glad you liked ✅️
BHAI, 99% APNE BOLA VAISE HI HOTA HAI 🎉🎉🎉😂❤
07:09 jo bhi gareeb hai ham logo ki tarha, bhai kyu hamari le rahe ho RUclips pe😂😂
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..
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
You have given END AS CustomerStatus but after query the column name comes in lowercase.Is SQL internally change to lower case in all alias cases?
Yes most of the sql database are not case sensitive but it's good practice to follow case sensitive in queries as it helps to improve readability
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
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, 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
I am also Gareeb Customer🤣😂
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''. 😂😂
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 mera es baar error araha hai
LINE 3: WHEN amount > 50 then 'expensive product'
^
how to solve this error sir please reply
type 'then' in caps....see whether it works or not
same like for loop in python
Bhola not sab kuch it is all records...you are a real Bhola urf Tambola🤣🤣🤣
Bhai odia ki?
Hi 👋 i m from Prayagraj
🤭😂