day01
๋ฐ์ดํฐ ์ ์์ด(DDL)
ํ ์ด๋ธ์ด๋ ๊ด๊ณ์ ๊ตฌ์กฐ๋ฅผ ์์ฑํ๋๋ฐ ์ฌ์ฉํ๋ฉฐ
create, alter, drop ๋ฌธ ๋ฑ์ด ์๋ค.๋ฐ์ดํฐ ์กฐ์์ด(DML)
ํ ์ด๋ธ์ ๋ฐ์ดํฐ๋ฅผ ๊ฒ์, ์ฝ์ , ์์ , ์ญ์ ํ๋๋ฐ
์ฌ์ฉํ๋ฉฐ select, intsert, delete, updata๋ฌธ ๋ฑ์ด ์๋ค.
(Create, Read , Update, Delete)๋ฐ์ดํฐ ์ ์ด์ด(DCL)
// ์์ ์ ๊ฑฐ์ ๋ค๋ฃจ์ง ์์๋ฐ์ดํฐ์ ์ฌ์ฉ ๊ถํ์ ๊ด๋ฆฌํ๋๋ฐ ์ฌ์ฉํ๋ฉฐ
grant, revoke ๋ฌธ ๋ฑ์ด ์๋ค.
๊ธฐ๋ณธ์์
SELECT EMPLOYEE_ID, LAST_NAME FROM EMPLOYEES WHERE LAST_NAME = 'ostin';
SELECT * // EMPLOYEE์ ๋ํ ๋ชจ๋ ์ปฌ๋ผ์ ๊ฐ์ ธ์ค๋๊ฒ
FROM EMPLOYEES
WHERE LAST_NAME = 'ostin';
SELECT *
FROM employees;
SELECT *
FROM EMPLOYEES e ;
SELECT EMPLOYEE_ID
, LAST_NAME , EMALL
, DEPARTMENT_ID, SALARY
FROM EMPLOYEES e ;
-- ํ์ค์ฃผ์
/*
* ์ฌ๋ฌ์ค ์ฃผ์
*/
-- employees ํ
์ด๋ธ์์
-- employee_id,salary, first_name
SELECT employee_id, salary, first_name
FROM EMPLOYEES e ;
/*
* where ์กฐ๊ฑด๋ฌธ
*/
SELECT EMPLOYEE_ID , SALARY , FIRST_NAME
FROM EMPLOYEES e
WHERE LAST_NAME = 'Smith'
;
# ๐ก ๋ฌธ1.
>employees ํ
์ด๋ธ์์ department_id๊ฐ 100์ด๊ณ
job_id๊ฐ FI_MGR์ธ ์ฌ๋์ ๋ชจ๋ ๋ฐ์ดํฐ ์กฐํ
>
```sql
SELECT *
FROM EMPLOYEES e
WHERE DEPARTMENT_ID = '100'
AND JOB_ID = 'FI_MGR'
;
employees ํ ์ด๋ธ์์ department_id๊ฐ 100์ด๊ณ
job_id๊ฐ FI_MGR์ธ ์ฌ๋์ ๋ชจ๋ ๋ฐ์ดํฐ ์กฐํSELECT * FROM EMPLOYEES e WHERE DEPARTMENT_ID = 100 AND JOB_ID = 'FI_MGR' ;
employees ํ ์ด๋ธ์์ first_name์ด Guy์ธ ์ฌ๋์
employee_id, first_name, last_name, job_id ์กฐํSELECT EMPLOYEE_ID , FIRST_NAME , LAST_NAME , JOB_ID FROM EMPLOYEES e WHERE FIRST_NAME = 'Guy' ;
employees ํ ์ด๋ธ์์ department_id๊ฐ 50์ด๊ณ
manager_id๊ฐ 121์ธ ์ฌ๋์
employee_id, first_name, last_name, job_id ์กฐํSELECT EMPLOYEE_ID , FIRST_NAME , LAST_NAME , JOB_ID FROM EMPLOYEES e WHERE MANAGER_ID = '121' AND DEPARTMENT_ID = '50' ;