- 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.
推薦閱讀
- 32位嵌入式系統(tǒng)與SoC設(shè)計(jì)導(dǎo)論
- 21小時學(xué)通AutoCAD
- 協(xié)作機(jī)器人技術(shù)及應(yīng)用
- WOW!Illustrator CS6完全自學(xué)寶典
- 機(jī)器人智能運(yùn)動規(guī)劃技術(shù)
- 機(jī)器自動化控制器原理與應(yīng)用
- 快學(xué)Flash動畫百例
- CentOS 8 Essentials
- CompTIA Linux+ Certification Guide
- Machine Learning with Apache Spark Quick Start Guide
- FPGA/CPLD應(yīng)用技術(shù)(Verilog語言版)
- 嵌入式操作系統(tǒng)原理及應(yīng)用
- INSTANT Adobe Story Starter
- 智慧未來
- Windows 7來了