title: GROUP BY one column; pick arbitrary value for another
body: <p>I am trying to select one row per user. I don't care which image I get. This query works in MySQL, but not in SQL Server:</p>
  
  <pre><code>SELECT user.id, (images.path + images.name) as 'image_path'
  FROM users
  JOIN images ON images.user_id = users.id
  GROUP BY users.id
  </code></pre>