# SQLite 3.35 의 새 기능

> Clean Markdown view of GeekNews topic #3883. Use the original source for factual precision when an external source URL is present.

## Metadata

- GeekNews HTML: [https://news.hada.io/topic?id=3883](https://news.hada.io/topic?id=3883)
- GeekNews Markdown: [https://news.hada.io/topic/3883.md](https://news.hada.io/topic/3883.md)
- Type: news
- Author: [xguru](https://news.hada.io/@xguru)
- Published: 2021-03-14T09:24:52+09:00
- Updated: 2021-03-14T09:24:52+09:00
- Original source: [nalgeon.github.io](https://nalgeon.github.io/sqlite-3-35/)
- Points: 4
- Comments: 0

## Topic Body

- Math 함수 : cos,sin,tan,log,ln,exp,floor,mod,pi,pow,power,radians,sqrt등

- 컬럼 삭제 : ALTER TABLE DROP COLUMN

- DELETE, INSERT, UPDATE 시 처리된 Row들 RETURNING 으로 받는게 가능

- Materialized CTEs : CTE실행시 쿼리 결과를 저장해서 같은 쿼리 안에서 재계산 안하게

## Comments



_No public comments on this page._