SQL Editor

SQL Lag Partition Example


List monthly sales for the year 2013. For each month include prior month's sales.
If there is no prior month, return 0. Also include the delta (difference) between the current and the prior month's sales.
Click here for details on LAG.
No records were found.
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.