title: The first row when single-row subquery returns more than one row
body: <p>My subquery returns more than one row and I need the first row and keep my max function    </p>
  
  <pre><code>Select ...
  Where GHTY_FIRME.FIRME_ID= (Select   FIRME_ID
                             FROM imag_verification_tube 
                             WHERE (numero_dossier =  '12004' OR NUMERO_TIRE= '12004')
                             AND CREE_LE = (select max (CREE_LE) 
                             from tableX where(numero_dossier ='12004' OR 
                             NUMERO_PQDCS= '12004 ')));
  </code></pre>