1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| SQL> select job,deptno,sum(sal) from emp where
to_char(hiredate,'YYYY-MM-DD') like '&date.%' group by job,deptno;
Enter value for date: 1981
old 1: select job,deptno,sum(sal) from emp where
to_char(hiredate,'YYYY-MM-DD') like '&date.%' group by job,deptno
new 1: select job,deptno,sum(sal) from emp where
to_char(hiredate,'YYYY-MM-DD') like '1981%' group by job,deptno
JOB DEPTNO SUM(SAL)
CLERK 30 1101.32
ANALYST 20 3477.83
MANAGER 10 2840.24
MANAGER 20 3448.85
MANAGER 30 3303.94
SALESMAN 30 6491.94
PRESIDENT 10 5796.38
SQL> select job,deptno,sum(sal) from emp where
to_char(hiredate,'YYYY-MM-DD') like '&date.%' group by job,deptno;
Enter value for date: 1981-02
old 1: select job,deptno,sum(sal) from emp where
to_char(hiredate,'YYYY-MM-DD') like '&date.%' group by job,deptno
new 1: select job,deptno,sum(sal) from emp where
to_char(hiredate,'YYYY-MM-DD') like '1981-02%' group by job,deptno
JOB DEPTNO SUM(SAL)
SALESMAN 30 3303.93 |
Partager