title: Raising salary by 15% using SQL only?
body: <p>I am trying to modify the <code>SCOTT</code> schema by raising employees salaries by 15%. If the resulting salary exceeds his or her highest possible salary, <code>HISAL</code>, in <code>SALGRADE</code> we just use <code>HISAL</code>, my code is: </p>
  
  <pre><code>select 
    coalesce((
      select   sal*1.15 
      from emp , salgrade  
      where 
        sal*1.15&lt;=hisal
     ) , 
     (select hisal from emp ,salgrade where sal*1.15&gt;hisal )) raised_sal
  from emp ;
  </code></pre>
  
  <p>The inner select returns multiple rows </p>
  
  <p>Does anyone have suggestions or different code?</p>