MYSQL 문제풀기

문제 출처

 

https://blog.naver.com/PostView.nhn?blogId=codingspecialist&logNo=221056527127&categoryNo=38&parentCategoryNo=0&viewDate=¤tPage=1&postListTopCurrentPage=1&from=postList

mysql 문제 1-10번

 

 

-- MYSQL 문제 1~10
SELECT EMPNO, ENAME , SAL
FROM EMP
WHERE DEPTNO = 10;

SELECT ENAME, HIREDATE, DEPTNO
FROM EMP
WHERE EMPNO = 7369;

SELECT * 
FROM EMP
WHERE ENAME = 'ALLEN';

SELECT ENAME, DEPTNO ,SAL
FROM EMP
WHERE HIREDATE = '80/12/17';

SELECT *
FROM EMP
WHERE JOB != 'MANAGER';

SELECT *
FROM EMP
WHERE HIREDATE > '81/04/02';

SELECT ENAME, SAL, DEPTNO
FROM EMP
WHERE SAL >= '800';

SELECT *
FROM EMP
WHERE DEPTNO >= '20';

SELECT *
FROM EMP
WHERE HIREDATE < '81/12/09';

SELECT EMPNO, ENAME
FROM EMP
WHERE EMPNO <= '7698';


-- MYSQL 문제 11~20
SELECT ENAME, SAL, DEPTNO
FROM EMP
WHERE HIREDATE > '81/04/02' AND HIREDATE < '82/12/09';

SELECT ENAME, JOB, SAL
FROM EMP
WHERE SAL > '1600' AND SAL < '3000';

SELECT *
FROM EMP
WHERE NOT EMPNO BETWEEN '7654' AND '7782';

SELECT *
FROM EMP
WHERE ENAME BETWEEN 'C%' AND 'J%';

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

SELECT *
FROM EMP
WHERE JOB = 'MANAGER' OR JOB = 'SALESMAN';

SELECT *
FROM EMP
WHERE DEPTNO != '20' OR DEPTNO != '30';

SELECT EMPNO, ENAME, HIREDATE, DEPTNO
FROM EMP
WHERE ENAME LIKE 'S%';

SELECT *
FROM EMP
WHERE SUBSTR(HIREDATE, 1, 2) = '81';

SELECT *
FROM EMP
WHERE ENAME LIKE '%S%';

SELECT *
FROM EMP
WHERE ENAME LIKE 'S%T';

SELECT *
FROM EMP
WHERE ENAME LIKE '_A%';

SELECT *
FROM EMP
WHERE COMM IS NULL;

SELECT *
FROM EMP
WHERE COMM IS NOT NULL;

SELECT *
FROM EMP
WHERE DEPTNO = '30' AND SAL > '1500';

SELECT EMPNO, ENAME, DEPTNO
FROM EMP
WHERE ENAME = 'K%' OR DEPTNO = '30';

SELECT *
FROM EMP
WHERE SAL >= '1500' AND DEPTNO = '30' AND JOB = 'MANAGER';

SELECT *
FROM EMP
WHERE  DEPTNO = '30' AND JOB = 'MANAGER';

SELECT *
FROM EMP
WHERE DEPTNO = '30'
ORDER BY 'SORT';

SELECT *
FROM EMP
ORDER BY SAL DESC;

SELECT *
FROM EMP
ORDER BY DEPTNO ASC, SAL DESC;

--30번까지 했음!