oracle树形结构层次查询.docVIP

king | ------------------------------------------------------------------------------- | | | jones blake clark | | | ---------------- -------------- milfr | | scott ford | | ad s [root@server1 ~]# su - oracle [oracle@server1 ~]$ sqlplus scott/tiger SQL*Plus: Release 10.2.0.1.0 - Production on Sun Aug 8 13:54:46 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SCOTTselect ename,sal from emp e,(select deptno,avg(sal) avg_sal from emp group by deptno) s where e.deptno=s.deptno; ENAME SAL ---------- ---------- SMITH 800 ALLEN 1600 WARD 1250 JONES 2975 MARTIN 1250 BLAKE 2850 CLARK 2450 SCOTT 3000 KING 5000 TURNER 1500 ADAMS 1100 JAMES 950 FORD 3000 MILLER 1300 14 rows selected. SCOTTselect ename,sal from emp e,(select deptno,avg(sal) avg_sal from emp group by deptno) s where e.deptno=s.deptno and e,sals.avg_sal; select ename,sal from emp e,(select deptno,avg(sal) avg_sal from emp group by deptno) s where e.deptno=s.deptno and e,sals.avg_sal * ERROR at line 1: ORA-00920: invalid relational operator SCOTTselect ename,sal from emp e,(select deptno,avg(sal) avg_sal from emp group by deptno) s where e.deptno=s.deptno and e.sals.avg_sal; ENAME SAL ---------- ---------- ALLEN 1600 JONES 2975 BLAKE 2850 SCOTT 3000 KING 5000 FORD 3000 6 rows selected. SCOTTed Wrote file afiedt.buf 1 select ename,sal