title: SQL select first records of rows for specific column
body: <p>I realize my title probably doesnt explain my situation very well, but I honestly have no idea how to word this.</p>
  
  <p>I am using SQL to access a DB2 database.</p>
  
  <p>Using my screenshot <strong>image 1</strong> below as a reference:</p>
  
  <p>column 1 has three instances of "U11124", with three different descriptions (column 2)</p>
  
  <p>I would like this query to return the first instance of "U11124" and its description, but then also unique records for the other rows.  <strong>image</strong> 2 shows my desired result.</p>
  
  <p><strong>image 1</strong></p>
  
  <p><img src="https://i.stack.imgur.com/5wiqf.jpg" alt="image1"></p>
  
  <p><strong>image 2</strong></p>
  
  <p><img src="https://i.stack.imgur.com/fqI5b.jpg" alt="image2"></p>
  
  <p>----- EDIT ----</p>
  
  <p>to answer some of the questions / posts:
  technically, it does not need to be the first , just any single one of those records.  the problem is that we have three descriptions, and only one needs to be shown, i am now told it does not matter which one.</p>