title: SELECT a variable as condition and display another one
body: <p>My problem is the following.</p>
  
  <p>I want to <code>SELECT</code> the minimum of a years list and display another row of my table.</p>
  
  <p>An example:</p>
  
  <pre><code>SELECT MIN(Year) 
  FROM table     -&gt; Searching for the lowest year.
  </code></pre>
  
  <p>and then I want it to display the <code>Winners</code> of the first year.</p>
  
  <p>Is there a way to do this in just one line?</p>