# chapter\_07

- [JOIN의 종류(INNER, LEFT, RIGHT, FULL)](/booil-jung/docs/dbms/postgresql/chapter_07/0701.md)
- [CROSS JOIN과 SELF JOIN 활용](/booil-jung/docs/dbms/postgresql/chapter_07/0702.md)
- [복합 JOIN 조건 설정](/booil-jung/docs/dbms/postgresql/chapter_07/0703.md)
- [서브쿼리 고급 활용(IN, EXISTS 등)](/booil-jung/docs/dbms/postgresql/chapter_07/0704.md)
- [WITH 구문(CTE) 소개 및 응용](/booil-jung/docs/dbms/postgresql/chapter_07/0705.md)
- [윈도우 함수 기본(OVER, PARTITION BY)](/booil-jung/docs/dbms/postgresql/chapter_07/0706.md)
- [순위 함수(RANK, DENSE\_RANK 등)](/booil-jung/docs/dbms/postgresql/chapter_07/0707.md)
- [이동 집계 함수(LAG, LEAD)](/booil-jung/docs/dbms/postgresql/chapter_07/0708.md)
- [GROUPING SETS, ROLLUP, CUBE](/booil-jung/docs/dbms/postgresql/chapter_07/0709.md)
- [복잡한 쿼리 튜닝을 위한 전략](/booil-jung/docs/dbms/postgresql/chapter_07/0710.md)