- Mastering PostgreSQL 9.6
- Hans Jurgen Schonig
- 117字
- 2021-07-09 19:57:24
Handling Advanced SQL
In the previous chapter, you learned about indexing as well as about PostgreSQL's ability to run custom indexing code to speedup queries. In this chapter you will learn about advanced SQL. Most readers of this book will have some experience of using SQL. However, experience has shown that those advanced features outlined in this book are not widely known and therefore it makes sense to cover them in this context to help people to achieve their goals faster and more efficiently.
The topics of this chapter are:
- Grouping sets
- Ordered sets
- Hypothetical aggregates
- Windowing functions and analytics
At the end of the chapter, you will be able to understand and use advanced SQL.
推薦閱讀
- 實時流計算系統設計與實現
- 計算機應用復習與練習
- 機器學習與大數據技術
- INSTANT Varnish Cache How-to
- Maya極速引擎:材質篇
- 21天學通Java Web開發
- Splunk Operational Intelligence Cookbook
- Lightning Fast Animation in Element 3D
- Kubernetes for Serverless Applications
- 步步圖解自動化綜合技能
- 分數階系統分析與控制研究
- Machine Learning with the Elastic Stack
- INSTANT Heat Maps in R:How-to
- 自動化生產線安裝與調試(三菱FX系列)(第二版)
- 單片機技術項目化原理與實訓