Get records from currentyear - 1

See more:

SQL

Hello freinds

I am doing some reporting on sales figures and would like to make some generic reports that will update as time goes by. This Means that I would like to get all sales from current year and in another report current year -1 and in the NeXT year -2.. Is this possible?

Right now i'm using the below to get the current year - but how to get -1 and -2 and so on..


= YEAR(GETDATE()))

My full SQL Query

SELECT CAST(SUM(Cust.[Sales (LCY)]) AS decimal(8 , 2)) AS Totalsales, Cust.[Customer No.], Customer.Name 
FROM [Cust. Ledger Entry] AS Cust INNER JOIN Customer ON Cust.[Customer No.] = Customer.[No.] 
WHERE (Cust.[Document Type] = 2) AND (YEAR(Cust.[Posting Date]) = YEAR(GETDATE())) 
GROUP BY Cust.[Customer No.], Customer.Name ORDER BY Totalsales DESC