title: CROSS APPLY getting the most recent date
body: <p>Currently my query is returning three records. The reason for this is that the CRT_STAT table has found 3 matching records. I would like to get the record that has the most recent date. My <code>CRT_STAT</code> table has a column called <code>DISPOSITION_DATE</code>. </p>
  
  <p>I need to add a date check in this part of the query where it selects the most recent date of the group of records it finds (in this case three).</p>
  
  <pre><code>CROSS APPLY (
      SELECT *
      FROM CCH_PUBLIC.dbo.CRT_STAT as crtStat
      WHERE crtStat.TRS_IDN = o.TRS_IDN 
      AND crtSTat.DISPOSITION_DATE ='DATE IS MOST RECENT OF THE THREE RECORDS FOUND'
  
  ) crtStat
  </code></pre>
  
  <p>What would be the most efficient way of doing this? </p>