- 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.
推薦閱讀
- 高性能混合信號(hào)ARM:ADuC7xxx原理與應(yīng)用開(kāi)發(fā)
- Spark編程基礎(chǔ)(Scala版)
- R Machine Learning By Example
- 手把手教你學(xué)AutoCAD 2010
- 圖形圖像處理(Photoshop)
- Learning Social Media Analytics with R
- 大數(shù)據(jù)挑戰(zhàn)與NoSQL數(shù)據(jù)庫(kù)技術(shù)
- Nginx高性能Web服務(wù)器詳解
- Learn CloudFormation
- 網(wǎng)絡(luò)布線與小型局域網(wǎng)搭建
- 計(jì)算機(jī)與信息技術(shù)基礎(chǔ)上機(jī)指導(dǎo)
- Learning Linux Shell Scripting
- 網(wǎng)絡(luò)服務(wù)器搭建與管理
- 機(jī)器學(xué)習(xí)案例分析(基于Python語(yǔ)言)
- Windows 7來(lái)了