Oracle 연습문제 . 데이터입력
CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL PRIMARY KEY, ENAME VARCHAR2(10), JOB VARCHAR2(9), HIREDATE DATE, SAL NUMBER(7, 2), COMM NUMBER(7, 2), DEPTNO NUMBER(2)); INSERT INTO EMP VALUES (7369, 'SMITH', 'CLERK', TO_DATE('17-12-1980', 'DD-MM-YYYY'), 800, NULL, 20);INSERT INTO EMP VALUES (7499, 'ALLEN', 'SALESMAN', TO_DATE('20-02-1981', 'DD-MM-YYYY'), 1600, 300, 30);INSERT INTO EMP VALUES (7521, '..
2012. 9. 24.
/*Over(partition by)*/ /*inner query*/
/*Over(partition by)*/ select employee_id, last_name, department_name, salaryfrom ( select employee_id, last_name,salary, department_name, max(salary) over (partition by d.department_id) as maxsal from employees e join departments d on e.department_id=d.department_id )where maxsal=salaryorder by employee_id asc; /*inner query*/select employee_id, last_name, department_name, salaryfrom employees ..
2012. 9. 24.