INSTR and SUBQUERY
358352Jun 20 2003 — edited Jun 20 2003Hello
I have to statements here that I don't understand. Can anyone explain what these two statements do.
In the first statement I don't know what the 3 and 2 is.
INSTR:
SELECT INSTR('CORPORATE FLOOR','OR', 3, 2) "Instring"
FROM DUAL;
SUB-SELECT:
SELECT a.ename, a.sal, a.deptno, b.salavg
FROM emp a, (SELECT deptno, avg(sal) salavg
FROM emp
GROUP BY deptno) b
WHERE a.deptno = b.deptno
AND a.sal > b.salavg;