title: Find the min/max value in a column of a DataTable with Where clause?
body: <p>Say for example I have this DataTable:</p>
  
  <p><a href="https://i.stack.imgur.com/HDFmG.png" rel="nofollow"><img src="https://i.stack.imgur.com/HDFmG.png" alt="enter image description here"></a></p>
  
  <p>Is it possible to get the min/max value of Day1 column based on the Year column? Possibly using a select statement?</p>
  
  <p>In SQL you would do:
  SELECT MIN(Day1), Max(Day1) FROM TST WHERE Year = 2015</p>