title: How to select max date using SQL without using group by clause . There are solutions for this which have group by clause I want solution without it
body: <p>I've following table:</p>
  
  <pre><code>PERSON_ID   EFFECTIVE_END_DATE      ASSIGNMENT_ID   FULL_NAME
  33151       2013-08-04 00:00:00.0   33885           Test, C
  33151       2013-10-04 00:00:00.0   33885           Test, C
  33151       2015-02-19 00:00:00.0   33885           Test, C
  33151       2013-08-04 00:00:00.0   33885           Test, C
  33151       2013-10-04 00:00:00.0   33885           Test, C
  33151       2015-02-19 00:00:00.0   33885           Test, C
  </code></pre>
  
  <p>Here <code>PERSON_ID</code> is same I want to select row with maximum effective end date without using <code>group by</code>. </p>
  
  <p>Can some one help me ?</p>