title: MYSQL equivalent of MS-Access function first() last()
body: <p>To better explain what I need please look at this table:</p>
  
  <pre><code>ID --- image
  A1 --- a1_01.jpg
  A1 --- a1_02.jpg
  B7 --- b7_01.jpg
  B7 --- b7_02.jpg
  D3 --- D3_04.jpg
  D3 --- D3_99.jpg
  ... (From A to Z)
  Z9 --- Z9_12.jpg
  Z9 --- Z9_13.jpg
  Z9 --- Z9_20.jpg
  Z9 --- Z9_99.jpg
  ...and so on
  </code></pre>
  
  <p><strong>I need the results to be:</strong></p>
  
  <pre><code>ID --- Image
  A1 --- a1_01.jpg
  B7 --- b7_01.jpg
  D3 --- D3_04.jpg
  ...
  Z9 --- Z9_12.jpg
  ...and so on
  </code></pre>
  
  <p>In MS-Access this is can be done with <code>SELECT ID, First(image) AS 'Image' FROM Photos</code></p>
  
  <p><strong>How can I accomplish this in MYSQL?</strong></p>
  
  <p>Remember that this is a mockup table, to illustrate my problem. I have tons and tons of records. IT IS NOT a single (least/most) value!</p>
  
  <p><strong>===EDIT: 11/24/2012===</strong>
  <br/>FINAL SQL CODE: </p>
  
  <pre><code>SELECT ID, Min(image) AS 'Image' 
  FROM Photos 
  GROUP BY ID
  </code></pre>
  
  <p>Thank you <a href="https://stackoverflow.com/users/532208/triclosan">@triclosan</a> &amp; <a href="https://stackoverflow.com/users/78522/idevlop">@iDevlop</a> !!!</p>