SELECT[DISTINCT] 열목록
FROM 테이블 [별칭][JOIN 다른테이블 ON 조건]WHERE 행조건
GROUPBY 묶는기준
HAVING 묶은뒤조건
ORDERBY 정렬기준 [ASC|DESC]LIMIT 개수 [OFFSET 건너뛸수];
SELECT*FROM blocks;-- 전부 (운영 코드에선 쓰지 않는다)SELECT block_id, name FROM blocks;SELECT block_id AS id, name AS 블록명 FROM blocks;-- 별칭SELECTDISTINCT category FROM blocks;-- 중복 제거
SELECT block_id, UPPER(name)AS upper_name, CONCAT(block_id,' · ', name)AS label, LENGTH(description)AS desc_len,ROUND(score,2)AS score2,COALESCE(alias, name)AS display,-- 앞이 NULL이면 뒤 DATE_FORMAT(created_at,'%Y-%m')AS ym
FROM blocks;
SELECT block_id,CASEWHEN score >=0.8THEN'high'WHEN score >=0.5THEN'mid'ELSE'low'ENDAS score_band
FROM blocks;
SELECT category,COUNT(*)AS total,SUM(CASEWHEN deprecated =1THEN1ELSE0END)AS deprecated_cnt
FROM blocks
GROUPBY category;
ORDERBY created_at DESC-- 내림차순ORDERBY category ASC, name DESC-- 여러 기준ORDERBY2-- 열 번호 (권장하지 않음 — 열이 바뀌면 깨진다)ORDERBYCASE category WHEN'model'THEN1ELSE2END, name -- 커스텀 순서
LIMIT20;-- 상위 20건LIMIT20OFFSET40;-- 41~60번째 (= 3페이지)
SELECT*FROM logs WHERE id >10000ORDERBY id LIMIT20;-- keyset
SELECT block_id FROM blocks_a
UNION-- 중복 제거 (정렬 비용 있음)SELECT block_id FROM blocks_b;SELECT...UNIONALLSELECT...;-- 중복 유지, 더 빠름