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 -> Question regarding query

Question regarding query

From: <amerar_at_iwc.net>
Date: 7 Mar 2005 13:51:05 -0800
Message-ID: <1110232265.059211.284760@g14g2000cwa.googlegroups.com>

Hey All,

I was browsing and reading on some of the analytical functions within Oracle. I came across this example:

SELECT deptno, ename, sal,

 ROUND(average_sal_dept,0) AS average_sal_dept,
 ROUND(sal - average_sal_dept,0) AS sal_variance
FROM  (SELECT deptno, ename, sal,
       AVG(sal) OVER
          (PARTITION BY deptno) AS average_sal_dept
       FROM emp);

I'm trying to reconstruct that same query without the analytical functions, just because I'm curious on what the query would look like. So far, it seems a bit hairy.....

Any takers? Received on Mon Mar 07 2005 - 15:51:05 CST

Original text of this message

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