Can you write a query to calculate the rolling sum?
AnswerBot
2mo
Query to calculate rolling sum
Use window functions like SUM() OVER() in SQL
Specify the window frame to define the range for the rolling sum
Example: SELECT date, value, SUM(value) OVER (ORDER BY date R...read more
K shilpa K shilpa
28d
SQL
Help your peers!
Add answer anonymously...
Swiggy Business Analyst interview questions & answers
A Business Analyst was asked 7mo agoQ. What is skewness and what are its types?
A Business Analyst was asked 7mo agoQ. How do you handle outliers?
A Business Analyst was asked 7mo agoQ. What is the difference between DDL and DML?
Popular interview questions of Business Analyst
A Business Analyst was asked 7mo agoQ1. What is skewness and what are its types?
A Business Analyst was asked 7mo agoQ2. How do you handle outliers?
A Business Analyst was asked 7mo agoQ3. What is the difference between DDL and DML?
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.
Follow us
