title: Group by and find MAx value in a DataTable rows
body: <p>I have existing code that works very well and it finds the maximum value of a data column in the data table. Now I would like to refine this and find the maximum value per empid.
  What change would be needed? I do not want to use LINQ.</p>
  
  <p>I am right now using this:  memberSelectedTiers.Select("Insert_Date = MAX(Insert_Date)")
  and I need to group it by Empid.</p>
  
  <p>My code is as below.</p>
  
  <pre><code>        DataTable memberApprovedTiers = GetSupplierAssignedTiersAsTable(this.Customer_ID, this.Contract_ID);
  
          //get row with maximum Insert_Date in memberSelectedTiers
          DataRow msRow = null;
          if (memberSelectedTiers != null &amp;&amp; memberSelectedTiers.Rows != null &amp;&amp; memberSelectedTiers.Rows.Count &gt; 0)
          {
             DataRow[]  msRows = memberSelectedTiers.Select("Insert_Date = MAX(Insert_Date)");
             if (msRows != null &amp;&amp; msRows.Length &gt; 0)
             {
                 msRow = msRows[0];
             }
          }
  </code></pre>