티스토리 뷰
DCL: GRANT, REVOKE
DDL: CREATE, ALTER, DROP
DML: INSERT, UPDATE, DELETE, SELECT
SELECT * FROM _TABLE_ WHERE _COLUMN_='VALUE'
INSERT INTO _TABLE_ (_COLUMN_) VALUES ('VALUE')
UPDATE _TABLE_ SET (_COLUMN_='VALUE') WHERE CONDITION
DELETE FROM _TABLE_ WHERE CONDITION
SELECT TOP 100 * FROM _TABLE_
SELECT * FROM _TABLE_ WHERE _COLUMN_ IN ('VALUE', 'VALUE')
2개의 TABLE JOIN
SELECT A.COL, B.COL FROM A INNER JOIN B ON A.ID = B.ID
3개의 TABLE JOIN
SELECT A.COL, B.COL, C.COL FROM (
(A INNER JOIN B ON A.COL = B.COL)
INNER JOIN C ON A.COL=C.COL)
'면접' 카테고리의 다른 글
feature selection (0) | 2022.08.04 |
---|---|
Model (0) | 2022.06.26 |
Model selection (0) | 2022.06.25 |
sklearn - K-NN, Linear, SVM (0) | 2022.06.25 |
데이터분석전공 (0) | 2016.10.24 |
- Total
- Today
- Yesterday
공지사항
최근에 올라온 글
글 보관함