오라클 SELECT , FROM, WHERE 문제

환경
윈도우10 64비트
오라클 18c 익스프레스

 

스캇 예제
예제를 확인하시려면

https://ondolroom.tistory.com/163

 

 

문제 링크

https://blog.naver.com/codingspecialist/221056527127

https://blog.naver.com/codingspecialist/221056538130

https://blog.naver.com/codingspecialist/221056546987

 

정답

SELECT *
FROM emp;

--1
SELECT empno, ename, sal
FROM emp
WHERE deptno = 10;


--2
SELECT ename, hiredate, deptno
FROM emp
WHERE empno = 7369;


--3
SELECT *
FROM emp
WHERE ename = 'ALLEN';

DESC emp;


--4
SELECT *
FROM emp
WHERE hiredate = '1980/12/17';


--5
SELECT *
FROM emp
WHERE job != 'MANAGER';


--6
SELECT *
FROM emp
WHERE hiredate > '1981/04/02';


--7
SELECT ENAME, SAL, DEPTNO
FROM emp
WHERE SAL >= 800;


--8
SELECT *
FROM emp
WHERE DEPTNO >= 20;


--9
SELECT *
FROM emp
WHERE hiredate < '1981/12/09';


--10
SELECT EMPNO, ENAME
FROM emp
WHERE EMPNO <= 7698;


--11
SELECT *
FROM emp
WHERE hiredate BETWEEN '1981/04/03' AND '1982/12/08';


--12
SELECT *
FROM emp
WHERE SAL BETWEEN 1601 AND 2999;


--13
SELECT *
FROM emp
WHERE SAL < 7654 OR SAL > 7782;


--14
SELECT *
FROM emp
WHERE REGEXP_LIKE(SUBSTR(ENAME, 1,1), '[C-I]');


--15
SELECT *
FROM emp
WHERE SUBSTR(HIREDATE, 1, 2) <> '81';


--16
SELECT *
FROM emp
WHERE JOB = 'SALESMAN' OR JOB = 'MANAGER';


--17
SELECT *
FROM emp
WHERE DEPTNO != 20 AND DEPTNO != 30;


--18
SELECT empno, ename, hiredate, deptno
FROM emp
WHERE SUBSTR(ENAME, 1, 1) = 'S';


--19
SELECT *
FROM emp
WHERE SUBSTR(HIREDATE, 1, 2) = '81';


--20
SELECT *
FROM emp
WHERE ENAME LIKE '%S%';


--21
SELECT *
FROM emp
WHERE ENAME LIKE 'S%' AND ENAME LIKE '%T';


--22
SELECT *
FROM emp
WHERE ENAME LIKE '_A%';


--23
SELECT *
FROM emp
WHERE COMM IS NULL;


--24
SELECT *
FROM emp
WHERE COMM IS NOT NULL;


--25
SELECT ENAME, SAL, DEPTNO, COMM
FROM emp
WHERE deptno = 30 AND sal >= 1500;


--26
SELECT empno, ename, deptno
FROM emp
WHERE SUBSTR(ENAME, 1, 1) = 'k' or deptno = 30;


--27
SELECT *
FROM emp
WHERE sal >= 1500 and deptno = 30 AND JOB = 'MANAGER';


--28
SELECT *
FROM emp
WHERE deptno = 30
ORDER BY EMPNO;


--29
SELECT *
FROM emp
ORDER BY SAL DESC;

--30
SELECT *
FROM emp
ORDER BY DEPTNO, SAL DESC;


--31
SELECT *
FROM emp
ORDER BY DEPTNO DESC, ENAME, SAL DESC;


--32
SELECT *
FROM emp
WHERE COMM IS NOT NULL
ORDER BY (SAL+COMM) DESC;


--33
SELECT ENAME, SAL, SAL*0.13 "BONUS", deptno
FROM emp
WHERE DEPTNO = 10;


--34
SELECT ENAME, deptno, SAL, sal*12+sal*1.5 "INCOME"
FROM emp
WHERE DEPTNO = 30;


--35
SELECT ENAME, SAL, sal*0.15
FROM emp
WHERE sal >= 2000;


--36
SELECT ENAME, SAL, sal-sal*0.1
FROM emp
ORDER BY sal DESC;