Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 9 Query Question.....Please help....

Re: Oracle 9 Query Question.....Please help....

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 17 Apr 2006 07:37:29 -0700
Message-ID: <1145284649.155013.105410@i39g2000cwa.googlegroups.com> 





OK, different hint:



select a.empno, a.sal + nvl(comm,0) as total_sal
from emp a


where (a.sal + nvl(a.comm,0) ) = (select max(b.sal + nvl(b.comm,0)) as
total_sal

                                                 from emp b)


/



EMPNO  TOTAL_SAL



---------- ----------


      7839       5000



HTH -- Mark D Powell --
Received on Mon Apr 17 2006 - 09:37:29 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US