title: how get first row from duplicata values Oracle SQL query
body: <p>Below you can find my table with values (there are no constraints on my table):</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT DISTINCT * FROM khalil;
  </code></pre>
  
  <p>outputs:</p>
  
  <blockquote>
  <pre><code>ID VALUE
  -- -------
   1 yassine
   1 khalil
   2 amine
  </code></pre>
  </blockquote>
  
  <p>I need to get the first row when I have duplicate values.</p>
  
  <p>I have two rows with <strong><code>id = 1</code></strong> so, in this case, I need that the first one,
  which is <strong><code>id = 1</code></strong> and <strong><code>value = 'yassine'</code></strong></p>