<p>I am writing a query in which I have to get the data for only the last year. What is the best way to do this?</p>

<pre><code>SELECT ... FROM ... WHERE date &gt; '8/27/2007 12:00:00 AM'
</code></pre>

The following adds -1 years to the current date:
```
```
SELECT ... From ... WHERE date > DATEADD(year,-1,GETDATE())
```
```