title: Oracle select min row from multiple results
body: <p>I have been trying to solve this for a while now, any help would be greatly appreciated.</p>
  
  <p>I have tables:</p>
  
  <pre><code>distributor(distributor_name, distributor_id)
  distributed(price, movie_id, distributor_id)
  movie(title, movie_id)
  </code></pre>
  
  <p>Each distributor has multiple records for movies at different prices.</p>
  
  <p>I am trying to select the minimum price for a particular movie and from what distributor</p>
  
  <p>so far I have tried:</p>
  
  <pre><code>select min(Price), Distributor from
  (select m.distributor_name as Distributor, d.price from 
  distributors m, distributed d, movies mo
  where
  mo.title = 'Movie Name' and mo.movie_id = d.movie_id and d.distributor_id = m.distributor_id)
  group by Distributor;
  </code></pre>
  
  <p>Which returns the minimum price for each distributor.</p>
  
  <p>If I run:</p>
  
  <pre><code>select min(Price)
  (select m.distributor_name as Distributor, d.price from 
  distributors m, distributed d, movies mo
  where
  mo.title = 'Movie Name' and mo.movie_id = d.movie_id and d.distributor_id = m.distributor_id);
  </code></pre>
  
  <p>It gives just the lowest price of that particular movie.</p>
  
  <p>How can I get the name of the distributor for the lowest price?</p>