That is some real dedication from you to contribute to this society. We have discussed regarding case when and you have made it. Hats off to you for your shear dedication and hard work. Keep it up bro❤
@@AshutoshKumaryt for 10k subscribers.. I got a Job as data analyst.. your videos help me a lot in my journey.. SQL tutorial videos and SQL project videos help me a lot. Project videos help me to enrich my portfolio.. and your tutorial videos give me concept clarity.. I wanna send you this message in email but not getting enough time from last month.. Thanks .. for your efforts.. your hard work, and commitment. You are helping n number of people.. Hat's off to you.. You are serving great cause in society.. Regards
I used case when statement for updating a single row of a column, it make the desired changes but it converted else row as NULL, so i guess its better to use only normal update statement for updating a single row data
Like the one question had asked to populate the month ,order value , currect month order value , previous month order value type then what happened I was doing it by lag function for previous month order value something like that but that was incorrect
I would like to make the vedio related to case when statement when the question is supposed to solve by using case when but in first time reading the question the window function is coming in mind
Advanced sql playlist (must watch) - ua-cam.com/play/PLbTF1OfX62c3RQ_ZFfyNBWVPdz_OWTMLG.html
That is some real dedication from you to contribute to this society. We have discussed regarding case when and you have made it. Hats off to you for your shear dedication and hard work. Keep it up bro❤
Thanks Raushan ,
Congratulations for 10000 sub 😀👍🎉❤️
Video on how to explain data analyst projects in interview like python eda projects and SQL+ tabluea projects and and SQL + excel projects
Hi Ashutosh a very warm good morning for the new vedio
u can mail ur question on ashutoshkr103@gmail.com
congratulations ashu.....
Thanks but for what ?
@@AshutoshKumaryt for 10k subscribers.. I got a Job as data analyst.. your videos help me a lot in my journey.. SQL tutorial videos and SQL project videos help me a lot. Project videos help me to enrich my portfolio.. and your tutorial videos give me concept clarity.. I wanna send you this message in email but not getting enough time from last month..
Thanks .. for your efforts.. your hard work, and commitment.
You are helping n number of people..
Hat's off to you.. You are serving great cause in society..
Regards
@@ayushsahu632 bahut bahut dhanyawad mere bhai , ashutoshkr103@gmail.com mera mail id ha let's connect
@@AshutoshKumaryt sure
comment no 002- do one project on e-commerce
I used case when statement for updating a single row of a column, it make the desired changes but it converted else row as NULL, so i guess its better to use only normal update statement for updating a single row data
Like the one question had asked to populate the month ,order value , currect month order value , previous month order value type then what happened I was doing it by lag function for previous month order value something like that but that was incorrect
I would like to make the vedio related to case when statement when the question is supposed to solve by using case when but in first time reading the question the window function is coming in mind
i was trying to update the column using case function in MYSQL it was showing error that we need to use where clause.
Make sure your syntax is right
No project videos ? Can we expect
yes
I think you have already decided to not to upload project videos 😮.
No no i wil
Thanks ..can i get your contact number Ashutosh.. need to get some guidance regarding my future. I am plsql developer for last 11 years.