Get data for last one year from database
<p>I want to get data records for last one year which is ordered by date. But problem is that I need the data starting from first day of that month of past year.</p>

<p>For example, if its 15-June-2016 today, then I need to get data from 1-June-2015.</p>

<p>I tried to do it with</p>

<pre><code>SELECT *
FROM Table
WHERE
   date &gt;= DATE_SUB(NOW(),INTERVAL 1 YEAR) 
ORDER BY date;
</code></pre>

<p>but Its not working.</p>