mysql grouping select lmost recent date
<p>I want to select the most recent date per PropertyId and Type from the sample table below.</p>

<pre><code>|PropertyId | Type | ExpiryDate
|1          |1     | 2017-01-20

|1          |1     | 2016-01-20  

|1          |2     | 2017-01-20

|1          |2     | 2016-01-20

|2          |1     | 2017-01-20

|2          |1     | 2016-01-20

|2          |2     | 2017-01-20

|2          |2     | 2016-01-20
</code></pre>

<p>So would be looking for the result :-</p>

<pre><code>|PropertyId | Type | ExpiryDate

|1          |1     | 2017-01-20

|1          |2     | 2017-01-20

|2          |1     | 2017-01-20

|2          |2     | 2017-01-20
</code></pre>