medium10 pts · first answer countswindow-functionssql
Month-over-month growth value
Revenue was ₹80 lakh in May and ₹92 lakh in June. What does this expression give on the June row?
100.0 * (revenue - LAG(revenue) OVER (ORDER BY month))
/ LAG(revenue) OVER (ORDER BY month)Discussion 0
Join free to post in the discussion.