title: Mysql minimum and maximum values of "rate" for each month
body: <p>I have a table with two fields - a field for &quot;date&quot; entered as day/month/year and a field &quot;rate&quot;</p>
  <blockquote>
  <p>date | rate</p>
  <p>24/01/05 | 1.9754<br />
  26/01/05 | 1.3723<br />
  ...<br />
  and so on</p>
  </blockquote>
  <p>So, I like to find  minimum and maximum values of &quot;rate&quot; for each month of year(s). My query selects only one row</p>
  <blockquote>
  <p>SELECT  DISTINCT DATE_FORMAT(date, '%d-%m-%y') as Date, MIN(rate) as r, MAX(rate) as mr FROM rates</p>
  </blockquote>