We help IT Professionals succeed at work.

How to calculate Last 2 months average sales in sql server

177 Views
Last Modified: 2018-09-11
How to calculate Last 2 months average sales in sql server (excluding the current month)
Comment
Watch Question

SQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
Thankyou Raja Jegan R sir...

I tried in CTE but u gave me optimised solution using select statement.. Thankyou sir..
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
Welcome, glad to assist..