title: Select first record in database
body: <p>Forgive me if I'm not explaining this properly. But I have the following records</p>
  
  <pre><code>yearID    franchID    name
  ---------------------------
  1966      ATL         Atlanta Braves
  1883      ATL         Boston Beaneaters
  1883      PHI         Philadelphia Quakers
  1936      ATL         Boston Bees
  1993      PHI         Philadelphia Phillies
  </code></pre>
  
  <p>But I want the starting year and original name of the franchise, so the output should look like this:</p>
  
  <pre><code>StartYear    franchI    name
  --------------------------------
  1883         ATL        Boston Beaneaters
  1883         PHI        Philadelphia Quakers
  </code></pre>
  
  <p>The SQL I have right now is this:</p>
  
  <pre><code>SELECT 
      MIN(yearID) as StartYear, franchID, name
  FROM dbo.LahmanTeams
  GROUP BY franchID, name;
  </code></pre>
  
  <p>That gives me the first output, but I'd like to get the original franchise name.</p>