쿼리 공부

POSTGRESQL FUNDAMENTALS
SELECT
ORDER BY
SELECT DISTINCT
WHERE
LIMIT
FETCH
IN
BETWEEN
LIKE
IS NULL
ALIAS
Joins
INNER JOIN
LEFT JOIN
SELF-JOIN
FULL OUTER JOIN
Cross Join
Natural Join
GROUP BY
HAVING
UNION
INTERSECT
EXCEPT
GROUPING SETS
CUBE
ROLLUP
Subquery
ANY
ALL
EXISTS
INSERT
UPDATE
UPDATE Join
Upsert
DELETE

복습 내용

• IN subquery
• LIKE pattern matching using (%, ) -> matches exact number of character