오늘부터 오라클 책을 통해서 전체적으로 다시 한 번 복습하려고 한다 📚
포스팅은 책에 있는 연습 문제를 푼 것 위주로 올리려고 한다
Chapter 05 셀렉트
SELECT *
FROM EMP
WHERE ENAME LIKE '%S';
SELECT EMPNO, ENAME, JOB, SAL, DEPTNO
FROM EMP
WHERE DEPTNO = 30 AND JOB = 'SALESMAN';
SELECT EMPNO, ENAME, JOB, SAL, DEPTNO
FROM EMP
WHERE DEPTNO IN (20, 30)
AND SAL > 2000;
SELECT * FROM EMP
WHERE SAL >= 2000 AND SAL <= 3000;
SELECT ENAME AS "사원 이름", EMPNO AS "사원 번호", SAL AS '급여', DEPTNO AS "부서 번호"
FROM EMP
WHERE ENAME LIKE '%E%'
AND DEPTNO = 30
AND SAL NOT BETWEEN 1000 AND 2000;
SELECT * FROM EMP
WHERE COMM IS NULL AND MGR IS NOT NULL AND JOB IN ('MANAGER', 'CLERK')
AND ENAME NOT LIKE '_L%';