title: Getting all row data from minimum value in a field in a SQL query (Oracle)
body: <p>I'm having trouble obtaining a row of all information from a SQL query by specifying the minimum value of a field. Below is a basic example of the data I'm using and what I am trying to obtain:</p>
  
  <pre><code>SELECT 1 AS NUM_, 'ABC' AS LET_ FROM DUAL
  UNION
  SELECT 2 AS NUM_, 'DEF' AS LET_ FROM DUAL
  UNION
  SELECT 3 AS NUM_, 'GHI' AS LET_ FROM DUAL;
  </code></pre>
  
  <p>The query above will yield the following result:</p>
  
  <pre><code>NUM_ | LET_
  -----------
    1  | ABC
    2  | DEF
    3  | GHI
  </code></pre>
  
  <p>I only want the row that has the data <code>1</code> and <code>ABC</code>. This is what I tried, below:</p>
  
  <pre><code>SELECT MIN(LN.NUM_) AS MIN_NUM, 
         LN.LET_ 
  FROM   (SELECT 1 AS NUM_, 'ABC' AS LET_ FROM DUAL
          UNION
          SELECT 2 AS NUM_, 'DEF' AS LET_ FROM DUAL
          UNION
          SELECT 3 AS NUM_, 'GHI' AS LET_ FROM DUAL) LN
  GROUP BY LET_;
  </code></pre>
  
  <p>But the above still gives me all of the rows. How do I zero in on just the row with the lowest value in the <code>NUM_</code> column, giving me <code>1</code> and <code>ABC</code>?</p>