SQL Server: Getting "before two days" date
<p>I have a select, and I need to limit data only for two last days. So today is 24th Aug 2016 so I need to get data for 24th Aug 2016, 23th Aug 2016 and 22th Aug 2016. How can I do that? I suppose I should use DATEADD function, or something similar. It needs to be done dynamicaly. </p>

<p>I need to get something like this:</p>

<pre><code>SELECT * FROM TABLE_NAME WHERE
DATE = '2016-08-22'
</code></pre>

<p>The date must be updated each day</p>