Link to home
Start Free TrialLog in
Avatar of Adimulam Yaswanth
Adimulam Yaswanth

asked on

How to calculate Last 2 months average sales in sql server

How to calculate Last 2 months average sales in sql server (excluding the current month)
ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Adimulam Yaswanth
Adimulam Yaswanth

ASKER

Thankyou Raja Jegan R sir...

I tried in CTE but u gave me optimised solution using select statement.. Thankyou sir..
Welcome, glad to assist..