SQL Editor

Tables and Columns 

Task:

List monthly sales for the year 2013. For each month include next month's sales.
If there is no prior month, return 0. Also include the delta (difference) between the current and the next month's sales.
Click here for details on LEAD.
 
 12 Records
Month Sales Next Month Delta
1 69409.60 41207.20 28202.40
2 41207.20 39979.90 1227.30
3 39979.90 55699.39 -15719.49
4 55699.39 56823.70 -1124.31
5 56823.70 39088.00 17735.70
6 39088.00 55464.93 -16376.93
7 55464.93 49981.69 5483.24
8 49981.69 59733.02 -9751.33
9 59733.02 70328.50 -10595.48
10 70328.50 45913.36 24415.14
11 45913.36 77476.26 -31562.90
12 77476.26 0.00 77476.26
Products
Pricing
Demos
Tutorials
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas.      Vsn 1.3.0