title: DB2 query group by id but with max of date and max of sequence
body: <p>My table is like</p>
  
  <pre><code>ID    FName LName Date(mm/dd/yy) Sequence Value
  101   A      B    1/10/2010      1       10 
  101   A      B    1/10/2010      2       20
  101   X      Y    1/2/2010       1       15
  101   Z      X    1/3/2010       5       10
  102   A      B    1/10/2010      2       10 
  102   X      Y    1/2/2010       1       15
  102   Z      X    1/3/2010       5       10
  </code></pre>
  
  <p>I need a query that should return 2 records </p>
  
  <pre><code>101   A      B    1/10/2010      2       20
  102   A      B    1/10/2010      2       10 
  </code></pre>
  
  <p>that is max of date and max of sequence group by id.</p>
  
  <p>Could anyone assist on this.</p>