-
SQL 정리 : 데이터 분석을 위한 SQL 기초너는 나의 에너지 2020. 2. 22. 16:24
SELECT
12SELECT column1, column2, ...(*)FROM table_name;cs WHERE
123SELECT column1, column2, ...FROM table_nameWHERE condition;cs AND OR NOT
1234567SELECT column1, column2, ...FROM table_nameWHERE condition1 AND(OR) condition2;SELECT column1, column2, ...FROM table_nameWHERE NOT condition;cs ORDER BY
123SELECT column1, column2, ...FROM table_nameORDER BY column1, column2, ... ASC|DESC;cs INSERT INTO
12INSERT INTO table_name (column1, column2, column3, ...)VALUES (value1, value2, value3, ...);cs NULL VALUES
123SELECT column_namesFROM table_nameWHERE column_name IS (NOT) NULL;cs UPDATE
123UPDATE table_nameSET column1 = value1, column2 = value2, ...WHERE condition;cs DELETE
1DELETE FROM table_name WHERE condition;cs MIN MAX
123SELECT MIN(column_name)FROM table_nameWHERE condition;cs COUNT AVG SUM
1234567891011SELECT COUNT(column_name)FROM table_nameWHERE condition;SELECT AVG(column_name)FROM table_nameWHERE condition;SELECT SUM(column_name)FROM table_nameWHERE condition;cs LIKE
123SELECT column1, column2, ...FROM table_nameWHERE columnN LIKE pattern; /* wildcards : %, _ */cs IN
1234567SELECT column_name(s)FROM table_nameWHERE column_name IN (value1, value2, ...);SELECT column_name(s)FROM table_nameWHERE column_name IN (SELECT STATEMENT);cs BETWEEN
123SELECT column_name(s)FROM table_nameWHERE column_name BETWEEN value1 AND value2;cs ALIAS
12SELECT column_name AS alias_nameFROM table_name;cs JOIN
123SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDateFROM OrdersINNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID;cs INNER JOIN
123SELECT column_name(s)FROM table1INNER JOIN table2 ON table1.column_name = table2.column_name;cs LEFT JOIN
123SELECT column_name(s)FROM table1LEFT JOIN table2 ON table1.column_name = table2.column_name;cs RIGHT JOIN
123SELECT column_name(s)FROM table1RIGHT JOIN table2 ON table1.column_name = table2.column_name;cs FULL OUTER JOIN
123SELECT column_name(s)FROM table1FULL OUTER JOIN table2 ON table1.column_name = table2.column_name;cs SELF JOIN
123SELECT column_name(s)FROM table1 T1, table1 T2WHERE condition;cs UNION
123SELECT column_name(s) FROM table1UNION (ALL)SELECT column_name(s) FROM table2;cs GROUP BY
12345SELECT column_name(s)FROM table_nameWHERE conditionGROUP BY column_name(s)ORDER BY column_name(s);cs HAVING
123456SELECT column_name(s)FROM table_nameWHERE conditionGROUP BY column_name(s)HAVING conditionORDER BY column_name(s);cs EXISTS
1234SELECT column_name(s)FROM table_nameWHERE EXISTS(SELECT column_name FROM table_name WHERE condition);cs ANY ALL
1234SELECT column_name(s)FROM table_nameWHERE column_name operator ANY(ALL)(SELECT column_name FROM table_name WHERE condition);cs CASE
123456CASEWHEN condition1 THEN result1WHEN condition2 THEN result2WHEN conditionN THEN resultNELSE resultEND;cs PROCEDURE
123456CREATE PROCEDURE procedure_nameASsql_statementGO;EXEC procedure_name;cs '너는 나의 에너지' 카테고리의 다른 글
아나콘다(Anaconda) 설치 : Jupyter Notebook 단축키 (0) 2020.03.09 tensorflow : python tensorflow 설치 시 에러 (1) 2020.03.06 안드로이드 서비스 : Android Service 정리, 종류, 생명주기 (0) 2020.02.17 IT SW개발 면접 후기 : 통신사 IT 기술면접 후기 및 질문 (0) 2020.02.17 산업통상자원부, 2020년 에너지기술개발 실행계획 (0) 2020.01.24