SQL Syntax

SELECT

1. 칼럼 조회

SELECT 칼럼명 FROM DB명.테이블명;

2. DISTINCT

중복 제거

SELECT DISTINCT 컬럼명 FROM DB명.테이블명;

WHERE

1. BETWEEN AND

특정 칼럼의 시작점 ~ 끝점 조건 설정

SELECT *
FROM DB명.테이블명
WHERE 칼럼명 BETWEEN 시작점 AND 끝점;

2. IN / NOT IN

SELECT 칼럼명
FROM DB명.테이블명
WHERE 칼럼명 (NOT) IN (값1, 값2...);

3. IS NULL / IS NOT NULL

null 값 확인

GROUP BY

SELECT (GROUP BY한)컬럼명, 집계함수(SUM, AVG, COUNT...(컬럼명))
FROM DB명.테이블명
GROUPO BY 컬럼명

JOIN

1. LEFT JOIN(LEFT OUTER JOIN)

2. INNER JOIN

3. FULL JOIN

CASE WHEN

SELECT
	CASE WHEN 조건1 THEN 결과1
    	 WHEN 조건2 THEN 결과2 ELSE 결과3 END
FROM DB명.테이블명;

RANK, DENSE_RANK, ROW_NUMBER

SELECT RANK() OVER(PARTITION BY 컬럼명 ORDER BY 컬럼명) FROM ...
SELECT DENSE_RANK() OVER(PARTITION BY 컬럼명 ORDER BY 컬럼명) FROM ...
SELECT ROW_NUMBER() OVER(PARTITION BY 컬럼명 ORDER BY 컬럼명) FROM ...

SUBQUERY