topn

nigelbayliss · nigelbayliss · commit c0816588d7ee · 2018-09-13T15:18:56.000+01:00
diff --git a/optimizer/topn/eg1.sql b/optimizer/topn/eg1.sql
@@ -1,4 +1,6 @@
-ELECT deptno, job, APPROX_SUM(sal),
+connect scott/tiger
+
+SELECT deptno, job, APPROX_SUM(sal),
        APPROX_RANK(partition by deptno ORDER BY APPROX_SUM(sal) desc) rk
 FROM   emp
 GROUP BY deptno, job
