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
3 ай бұрын
Thank you so much for this tutorial! 3 weeks of SQL done, started 4th week today. 🎉
@Travelling_With_Kamalu
Жыл бұрын
Thank you bhai - ( for the Case statement )
@rithikahuja8203
Жыл бұрын
Greatest and easiest explanation of every topic ❤❤thank you rishabh bhaiya for this tutorial
@RishabhMishraOfficial
Жыл бұрын
Glad you liked it ✨️
@ApurvGolatgaonkar
7 ай бұрын
Thank you bro .. Nice teaching
@RishabhMishraOfficial
7 ай бұрын
Glad you liked ✅️
@kaminibobade6539
Жыл бұрын
You have explained it in superb way , thank you so much and please share more projects of sql
@RishabhMishraOfficial
Жыл бұрын
Thank you, I will ✨️
@himanshumalik1023
Жыл бұрын
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 ??
@RishabhMishraOfficial
Жыл бұрын
Yes, it happens in the beginning. Solution is easy practice more sql questions
@shaziyasubhani448
10 ай бұрын
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
@prasadharihar6341
11 ай бұрын
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🙏👌
@RishabhMishraOfficial
11 ай бұрын
Glad it was helpful ✅️
@prasadharihar6341
11 ай бұрын
@@RishabhMishraOfficial really thank you sir🙏means a lot
@mahendraprajapati9809
Жыл бұрын
Very nice and informative SQL videos Thank you very much
@RishabhMishraOfficial
Жыл бұрын
Glad you liked it ✅️
@iamprashantverma
Жыл бұрын
Thank you so much sir
@RishabhMishraOfficial
Жыл бұрын
Happy to help ✅️
@rohanbilwal6974
9 ай бұрын
You made SQL easy bro!
@RishabhMishraOfficial
9 ай бұрын
Glad it helped! ✅️
@talkswithRishabh
11 ай бұрын
well explained thanks for that
@RishabhMishraOfficial
11 ай бұрын
Glad it helped ✅️
@mahidubey633
5 ай бұрын
7:09 Emotional Damage🥹🥲
@deepakyenagandula8729
Жыл бұрын
Really very good explanation bro
@RishabhMishraOfficial
Жыл бұрын
Glad you liked it ✅️
@himanshubhatt5562
Жыл бұрын
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
@nishikantanayak7797
3 ай бұрын
maza agaya sir
@turkeyjobsprovider
Жыл бұрын
Business Analyst Cours ka full tutorial bnay hindi me plz sir
@RishabhMishraOfficial
Жыл бұрын
Okayy done! will make it soon!
@noumanibrahim8895
Жыл бұрын
Thanks for aplaod these awesome lectures but please also drop link of data set in description.
@RishabhMishraOfficial
Жыл бұрын
Done brother, added all the links
@dr.nehachaudhry3526
Жыл бұрын
Well explained Sir👍
@RishabhMishraOfficial
Жыл бұрын
Glad it was helpful ✅️
@dr.nehachaudhry3526
Жыл бұрын
@@RishabhMishraOfficial yes it was quite helpful 👍😊
@sahilpatel1327
Жыл бұрын
good work. Keep it up
@RishabhMishraOfficial
Жыл бұрын
Glad you liked ✅️
@shivarajnavalba5042
Жыл бұрын
Thanks bro ❤
@RishabhMishraOfficial
Жыл бұрын
Glad you liked it ✅️
@poojasarkar2300
2 ай бұрын
same like for loop in python
@fog2640
11 ай бұрын
finished watching
@biswajeetdhal5364
Жыл бұрын
Sir, how to write case statements using CTE?? please can you tell..
@datalover120
7 ай бұрын
with cte as ( select *, case when quantity =3 and quantity
@biswajeetdhal5364
7 ай бұрын
@@datalover120 thanks bro..
@SagarKumar-nh3no
Жыл бұрын
Sir, if possible, please upload the video on daily basis and complete this course..
@RishabhMishraOfficial
Жыл бұрын
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
@balikatawale4820
Жыл бұрын
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
@RishabhMishraOfficial
Жыл бұрын
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
@guddy23k
5 ай бұрын
Select sabkuch was 😅fun
@sachinkuchgave7365
Жыл бұрын
Can you please tell me how to wtite query when cust_id is null then cust_name should be 'not applicable'
@RishabhMishraOfficial
Жыл бұрын
Easy, UPDATE table_name SET cust_name = 'not applicable' WHERE cust_id IS NULL
@sachinkuchgave7365
Жыл бұрын
@@RishabhMishraOfficial just want to display it in result set not in table
@sachinkuchgave7365
Жыл бұрын
@@RishabhMishraOfficial dont want to update in table
@SC-mx4wp
2 ай бұрын
BHAI, 99% APNE BOLA VAISE HI HOTA HAI 🎉🎉🎉😂❤
@lupinarsene1657
Жыл бұрын
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?
@atulpal4986
Жыл бұрын
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.
@kareem6557
Жыл бұрын
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
@piali1234
Жыл бұрын
there is a comma after amount in the select statement
@kareem6557
Жыл бұрын
@@piali1234 yeah i solved it beo thanks
@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
@mitheshshetty5842
6 күн бұрын
type 'then' in caps....see whether it works or not
@harshamannem5006
2 ай бұрын
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
@virendrakashyap4588
12 күн бұрын
7:07 jo log gareeb hai hum logo ki tarahh 🤣😂🤣 kya baat hai sir itna sach nhi bolna tha😅
@RishabhMishraOfficial
11 күн бұрын
😅😅
@AkashKumar-jl3sw
2 ай бұрын
07:09 jo bhi gareeb hai ham logo ki tarha, bhai kyu hamari le rahe ho KZitem pe😂😂
@DeepakV-jf3nb
Жыл бұрын
The kind of explanation is good ''Mehengawala'', ''Sastawala''. 😂😂
@onlysuhailff
5 ай бұрын
I am also Gareeb Customer🤣😂
@satyamsingh3511
Жыл бұрын
Bhai odia ki?
@RishabhMishraOfficial
Жыл бұрын
Hi 👋 i m from Prayagraj
@guddy23k
5 ай бұрын
🤭😂
@ankitbhatnagar8395
Жыл бұрын
Bhola not sab kuch it is all records...you are a real Bhola urf Tambola🤣🤣🤣
Пікірлер: 71