= 4000;
SELECT empno, ename, sal FROM emp WHERE ename >= 'W';
SELECT empno, hiredate FROM emp;
SELECT empno, hiredate FROM emp WHERE hiredate >= '81/12/25';
SELECT empno, ename, sal FROM emp WHERE sal >= 2000 and sal <= 3000;
SELECT empno, ename,">
= 4000;
SELECT empno, ename, sal FROM emp WHERE ename >= 'W';
SELECT empno, hiredate FROM emp;
SELECT empno, hiredate FROM emp WHERE hiredate >= '81/12/25';
SELECT empno, ename, sal FROM emp WHERE sal >= 2000 and sal <= 3000;
SELECT empno, ename,">
= 4000;
SELECT empno, ename, sal FROM emp WHERE ename >= 'W';
SELECT empno, hiredate FROM emp;
SELECT empno, hiredate FROM emp WHERE hiredate >= '81/12/25';
SELECT empno, ename, sal FROM emp WHERE sal >= 2000 and sal <= 3000;
SELECT empno, ename,">
SELECT * FROM emp;
SELECT * FROM tab;
SELECT empno, ename FROM emp;
SELECT profno, name FROM professor;
SELECT profno AS 교수번호, name AS 교수이름 FROM professor;
SELECT deptno FROM emp;
SELECT DISTINCT deptno FROM emp;
SELECT ename, job FROM emp;
SELECT ename || job FROM emp;
SELECT ename || ' ''s job is ' || job "NAME AND JOB" FROM emp;
SELECT empno, ename, sal FROM emp WHERE ename = SMITH;
SELECT empno, ename, sal FROM emp WHERE ename = 'SMITH';
SELECT empno, ename, sal FROM emp WHERE ename = 'smith';
SELECT empno, ename, hiredate FROM emp WHERE ename = 'SMITH';
SELECT empno, ename, hiredate FROM emp WHERE hiredate = '80/12/17';
SELECT ename, sal, sal+100, sal*1.1 FROM emp WHERE deptno = 10;
SELECT empno, ename, sal FROM emp WHERE sal >= 4000;
SELECT empno, ename, sal FROM emp WHERE ename >= 'W';
SELECT empno, hiredate FROM emp;
SELECT empno, hiredate FROM emp WHERE hiredate >= '81/12/25';
SELECT empno, ename, sal FROM emp WHERE sal >= 2000 and sal <= 3000;
SELECT empno, ename, sal FROM emp WHERE sal BETWEEN 2000 AND 3000;
SELECT ename FROM emp;
SELECT ename FROM emp WHERE ename BETWEEN 'JAMES' AND 'MARTIN';
SELECT ename, hiredate FROM emp;
SELECT ename, hiredate FROM emp WHERE hiredate BETWEEN '81/01/01' AND '81/05/31';
SELECT empno, ename, deptno FROM emp WHERE (DEPTNO = 10) OR (DEPTNO = 20);
SELECT empno, ename, deptno FROM emp WHERE DEPTNO IN(10, 20);
SELECT empno, ename, sal FROM emp;
SELECT empno, ename, sal FROM emp WHERE ename LIKE 'J%';
SELECT empno, ename, comm FROM emp;
SELECT empno, ename, comm FROM emp WHERE comm = null;
SELECT empno, ename, comm FROM emp WHERE comm IS NULL;
SELECT empno, ename, comm FROM emp WHERE comm IS NOT NULL;
SELECT empno, hiredate, sal FROM emp WHERE hiredate > '82/01/01' AND sal >= 1300;
SELECT empno, hiredate, sal FROM emp WHERE hiredate > '82/01/01' OR sal >= 1300;
SELECT ename, sal, hiredate FROM emp;
SELECT ename, sal, hiredate FROM emp ORDER BY ename;
SELECT deptno, sal, ename FROM emp ORDER BY deptno ASC, sal DESC;
SELECT ename, sal, hiredate FROM emp ORDER BY 2,1;
