# chapter\_06

- [SELECT 문 기본 구조](/booil-jung/docs/dbms/postgresql/chapter_06/0601.md)
- [WHERE 절과 필터링](/booil-jung/docs/dbms/postgresql/chapter_06/0602.md)
- [ORDER BY와 정렬 옵션](/booil-jung/docs/dbms/postgresql/chapter_06/0603.md)
- [LIMIT, OFFSET 활용](/booil-jung/docs/dbms/postgresql/chapter_06/0604.md)
- [INSERT 문과 반환값 처리](/booil-jung/docs/dbms/postgresql/chapter_06/0605.md)
- [UPDATE 문과 동시성 고려](/booil-jung/docs/dbms/postgresql/chapter_06/0606.md)
- [DELETE 문과 TRUNCATE 차이](/booil-jung/docs/dbms/postgresql/chapter_06/0607.md)
- [RETURNING 절의 활용](/booil-jung/docs/dbms/postgresql/chapter_06/0608.md)
- [서브쿼리 기본](/booil-jung/docs/dbms/postgresql/chapter_06/0609.md)
- [집계 함수(AVG, COUNT, SUM 등) 활용](/booil-jung/docs/dbms/postgresql/chapter_06/0610.md)