title: Lambda Expression Select Min and Max at the same time
body: <p>How do I convert this code to a Lambda expression when there are two columns to select at the same time?</p>
  
  <p><strong>LINQ</strong></p>
  
  <pre><code>var lq=(from a in tbl
            group a by 0 into b
            select new { intYear = b.Min(p =&gt; p.intYear), tintMonth = b.Max(p =&gt; p.tintMonth) }
      ).SingleOrDefault();
  </code></pre>
  
  <p><strong>T-SQL</strong></p>
  
  <pre><code>SELECT MIN(intYear), MAX(tintMonth)
  FROM tbl
  </code></pre>
  
  <p><strong>Lambda Expression</strong></p>
  
  <pre><code>tbl.Select(x =&gt; x.intYear).Min();  //Can't figure how to select if 2 columns
  </code></pre>