I have already gone through your previous video , due to which i was able to solve this problem before watching solution part .Thank you for the awesome content !
Great tutorial, sir. Getting the running total or cumutive is very common in business and statistics. Honestly i feel that SQL must have a very simple straitforward way of getting that instead of a cumbersome or convulte way!
Hey Ashutosh, For me : --- First table --> select * , sum(Sales) over( order by date) from runningSum; -this is also working and I haven't gone through your row between video but can you check if that is important over her. ---Second Table---> select * , sum(sales) over (partition by State order by date ) running_Sum from runningSum2; -same for this one
select *, sum(Sales) over(partition by State order by Date) from running_sum_partition; select *, sum(Sales) over(partition by State order by Date rows between unbounded preceding and current row) from running_sum_partition; if i execute both query separetly getting same answer. In second query if we don't use rows between still getting same answer. could you please clarify it?
Hey Ashutosh can you tell me how to find the rolling sum or moving average in case the some of the dates in between don't have their respective Sales values.
thank you sir, main Non It ka hoon aur main is Query ko 3 saal se dhoond raha tha. bhut si mili bhi lekin results jo chahiye tha wo nhi mila abb ja kar mila
👉 SQL Portfolio Project Indian Census- Part 1
ruclips.net/video/I3YvjFfn478/видео.html
One of the most underrated channel for SQL Tutorial. Keep it up bro! 🙏👍
I have already gone through your previous video , due to which i was able to solve this problem before watching solution part .Thank you for the awesome content !
Thanks, that's the idea behind the playlist
Great tutorial, sir. Getting the running total or cumutive is very common in business and statistics. Honestly i feel that SQL must have a very simple straitforward way of getting that instead of a cumbersome or convulte way!
Thanks
awesome sql interview video series kindly continue as per 2024 standard interview question
Too good way explained.
Request you please make same kind of videos on other topics also
Thx
Hey Ashutosh,
For me :
--- First table -->
select * , sum(Sales) over( order by date) from runningSum;
-this is also working and I haven't gone through your row between video but can you check if that is important over her.
---Second Table--->
select * , sum(sales) over (partition by State order by date ) running_Sum from runningSum2;
-same for this one
Yes this too works , thanks
great way of explaining! tysm
select *, sum(Sales) over(partition by State order by Date) from running_sum_partition;
select *, sum(Sales) over(partition by State order by Date rows between unbounded preceding and current row) from running_sum_partition;
if i execute both query separetly getting same answer. In second query if we don't use rows between still getting same answer.
could you please clarify it?
Hi Ashutosh
can you please provide the exact table or exact Excel sheet (in that github link not able to find the table)
you can't see a download button?
Thanks for this concept. Very well explained!!
Thanks a lot
Hey Ashutosh can you tell me how to find the rolling sum or moving average in case the some of the dates in between don't have their respective Sales values.
Put the sales value as 0 then calculate
Very good👍
I am not able to understand why unbounded following doesn't work, if unbounded preceding has no problem
Finished watching
thank you sir, main Non It ka hoon aur main is Query ko 3 saal se dhoond raha tha. bhut si mili bhi lekin results jo chahiye tha wo nhi mila abb ja kar mila
Kya baat ha, pehli baar Aisa kuch suna
Exalant
can you change the intro buzz music 😅.. besides vdos are very knowlegable
Right that is so loud.
kand fatt gye
same question ask to me in SQL interview
Maja aa gaya
Thanks