SQL Server queries SQL statements from the database for today's data from the last year

Because a small feature of recent projects requires a comparison of current data and history today. On the internet also looked for a long time, many are to achieve within one months, all the data in a year, last night suddenly found the following implementation method, in SQL Server2008 tried, it is I want results. Therefore wrote an essay, if later still need to be able to find, in addition also hope can help the people who need.

SELECT * from the history where Savetime= (select DateAdd (Yy,-1,getdate ()))

Where history is the name of the database, Savetime is the field that represents the time, and select DateAdd (Yy,-1,getdate ()) is the moment of last year's realization.

SQL Server queries SQL statements from the database for today's data from the last year