티스토리 뷰

면접

SQL

데이터조이 2022. 6. 26. 13:44

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
공지사항
최근에 올라온 글
글 보관함